Basics are a few macro's to:
- set the color to red or green
- make an appointment by adding a row with details on another sheet
- add the row number of the appointment to the red cells
- jump to that row to see the details for a selected red cell
My dentist has a ready made application package like this for his appointments. But that would be too expensive for you, I think, and not fully applicable (I'm identified by name and birthdate).
For my business, I schedule air quality tests in homes that last for 48 hours. Does anyone have recommendations for scheduling/appointment software (free or cheap would be nice). The only (emphasis added) feature I am looking for is an easy to see graphical view of free and busy times. For instance, a time & day separated matrix that shows green for open and red for closed. That way, I could easily recommend a time to a customer on the phone.
using windows 7.