Making a vet calendar using Excel 2007 and VBA
This project makes use of Excel 2007 to provide a vet with custom made calendar sheets that can be printed out for the whole year.
Conditional formatting indicates special hours in the calendar or special holidays occurring during the year.
The VBA programming is used to printout the calendar sheets recto verso for the 365 days in the year.
Sorry, no download available yet
Settings sheet: It is retains and centralizes the settings for the calendar used by different conditional formatting cells.
|
A simple printout form: For printing one month using a manual recto-verso technique.
Different messages appear in this form to inform the vet of the different printout steps to be taken for a manual recto-verso printout.
|
Year planner sheet: An extra page with 12 month blocks using conditional formatting and other formula tricks to indicate special dates defined in the centralized settings sheet.
|
Detailed printing form: To manually reprint a specific date range or one day.
|
Detail Page: This page is used by the vet to fill in several details, messages, operations that happened or are scheduled during that day.
|
Calendar sheet: This is the actual vet's calendar page per half hour. Conditional formatting is used to indicate special consultancy or open consultancy hours. The specific data of these hours are centrally managed in the settings sheet.
|
|
|