+ Reply to Thread
Results 1 to 5 of 5

Create automatically populated calendar using data from existing scheduler

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,434

    Re: Create automatically populated calendar using data from existing scheduler

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

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

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Create automatically populated calendar using data from existing scheduler

    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:

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

    Please Login or Register  to view this content.
    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?

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,434

    Re: Create automatically populated calendar using data from existing scheduler

    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

  5. #5
    Registered User
    Join Date
    05-22-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Create automatically populated calendar using data from existing scheduler

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1