+ Reply to Thread
Results 1 to 3 of 3

Programming Excel Calendar to Auto Populate

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Programming Excel Calendar to Auto Populate

    Hello Everyone,
    I am in desperate need of help! My work requires me to constantly update calendar events that revolve around a few dates which always changes (#vent 1 happens 21 days before date#1, Event 2 hapens 14 days after date#1, Event 3 happens 21 days before date#3, etc). People here like to visually see the dates plotted on a calendar on excel and the problem is that for any project, we could have upto 50 events and I work on something like 40 projects at a time and they CONSTANTLY CHANGE THE KEY DATES! so i end up spending several hours manually updating the calendar. I would like to be set up a 12 month at a glance calendar on one sheet and have date in the other where i can just input the formula (since that part is static) and then just change the key dates and all will update and post onto the calendar. I've seen something similar on the post - but not quite what i need. I've attached 2 files for reference. I hope someone can help. Thank you all in advance for your help.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Programming Excel Calendar to Auto Populate

    Hello briancuasito,

    Have you considered using Outlook instead of Excel? It has far better capability for scheduling and doesn't require you to write code for the calendar.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    08-19-2009
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Programming Excel Calendar to Auto Populate

    It would not suit our needs unfortunetly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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