few ... ?
a) Why each month has own sheet? ... How many sheets can You see one time?
b) Could You data-sheet be like? --- One task - start date/time, length, CustID, 'what' - per row in data
c) Holidays --- Other 'non'-tasks as some specific days and so on
>> those could show as in Your 'calendar'-sheet - monthly and per day with details.
... but, of course ... You're doing that for Yourself
So far look at row 64 on Events sheet. I think this may work with some adjusting. I could hide the other rows above to make it easier for data entry. These will now show on the calendar month for appointments.
BJ576
... still one ... idea of layout
I've used this kind of weekly calendar layout. Note: Now, this is only rough sample of layout.
Week selection could do with left side calendar ..
There (left) could colors to show different tasks.
Week-layout could show daily task based time.
... of course, the data = tasks are now missing and so on ...
