Create automatically populated calendar using data from existing scheduler

Hello.

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

Check out the attachment in post #4 of this thread:

http://www.excelforum.com/excel-prog...ndar-help.html

Hope this helps.

Pete

Pete, thank you for that.

I'm tailoring this to suit my purposes - it is working beautifully.

I just have one more question, if I may... In order to generate the notes showing what sort of booking I have, I'm concatenating as follows:

=CONCATENATE("WEDDING ",'[Celebrant Spreadsheet.xlsm]General details'!$A2)
=CONCATENATE("NOIM Lodgement ",'[Celebrant Spreadsheet.xlsm]General details'!$A2)
=CONCATENATE("Rehearsal ",'[Celebrant Spreadsheet.xlsm]General details'!$A2)

... and then the following three cells should increment the reference "General details" to $A3. must be incremented by 1, so that it's :

=CONCATENATE("WEDDING ",'[Celebrant Spreadsheet.xlsm]General details'!$A3)
=CONCATENATE("NOIM Lodgement ",'[Celebrant Spreadsheet.xlsm]General details'!$A3)
=CONCATENATE("Rehearsal ",'[Celebrant Spreadsheet.xlsm]General details'!$A3)

Clearly that is going to be far too difficult to copy and edit manually. Is there an easy way to achieve the result I need?

I'm not sure where you are putting those formulae, but they seem to imply that you are keeping the files separate - I would have thought that you could drag the sheets from my file into yours and then make a few adjustments there.

It is possible to build up the equivalent of those formulae using INDIRECT or INDEX, such that you could copy them down and they would retain the relative row numbers for each block, but I would need to see your file.

Pete

My apologies for not replying earlier. (A crisis with my father who's been in ICU for the last 5 weeks after a heart operation; his heart stopped again on Friday, and they've now inserted a pacemaker.)

I will just leave this for now; and thank you for your help.

- A