Greetings!
I have seven employees for whom I would like to create a rotating appointment schedule. I would like to list the employees in order, then when a client calls to make an appointment, enter the appointment day and time and the customer's name, have Excel reference the employee work schedule, choosing the first employee on the list who is scheduled to work during the appointment time, then move that employee to the "Employee" cell associated with that customer. I would then need to have a "Complete" button to return that employee to the bottom of the "Available" list and to clear the customer, day, and date information.
On the "Appointments" tab of the attached Excel File I show the Employee Available List, 4 slots for appointments, and the location of the "Complete" button. On the "Schedule" tab I have entered the employee's schedules.
I presume this needs a macro, but would appreciate any insight or direction.
Thank you! Carl