I've created a spreadsheet to take over the function of some software which I cannot re-install once my old computer died. (Specialist marriage celebrant software.)
It involves quite a few worksheets; I need to collect required information which makes it very specialised.
However, what I DON'T have is a visual calendar that shows my appointments for the month (and I must manually scan my schedule to ensure I'm not double-booking).
Is there a way to get the bookings from this spreadsheet into a visual calendar in Excel? (Either as another worksheet or as a separate spreadsheet document.)
And - I suppose this is a long shot! - is there any way to alert myself if I am double-booking myself?
I've attached a copy of the spreadsheet here, with dummy information.
Excel Celebrant Spreadsheet layout (with dummy details).zip