+ Reply to Thread
Results 1 to 16 of 16

Auto Populate Calendar from Table Excel

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2003
    Posts
    2

    Auto Populate Calendar from Table Excel

    I posted this question in my introduction, but I think I was supposed to post this in the general section:

    Hi, I currently work as an event coordinator for the Hispanic chamber of commerce. My company is working on tracking all marketing instances and I would like to find out how to create a very simple auto populating excel calendar.

    Specifics of what I need:

    I need to auto populate a calendar with a list of marketing instances. I have a table that lists the date and market instance of an event. for example the table will have the date 7/2/2012 and next to it breakfast networking 7/26, facebook post. all those entries need to be auto populated in a calendar. Sometimes there are several instances in one day. it would be nice to list them, i would need this calendar on a legal size or tabloid size paper.

    Attached is a document that I have been working on from this forum, but it does not provide several lines to work on, it isn't big enough for the amount of instances that I might have. Also if I have several instances I would like to input in the table separately instead of in one cell, but have it show up on the same day together.

    Thank you for any help given, it is really nice to connect with experienced people in excel!
    Attached Files Attached Files

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

    Re: Auto Populate Calendar from Table Excel

    Take a look at the attachment in post #10 of this thread:

    http://www.excelforum.com/excel-prog...html?p=2768117

    This allows you to enter events/activities in any order and then puts them in the correct day on the Calendar sheet, with up to 7 events per day. You can select the month and year of interest using the drop-downs.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Auto Populate Calendar from Table Excel

    thank you for solving my question!

  4. #4
    Registered User
    Join Date
    09-17-2012
    Location
    Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Auto Populate Calendar from Table Excel

    I can't get the month and date to update on the calendar ...

    I've selected the month of September and chosen 2012. I imagine it's supposed to then update the actual calendar to the left with the new dates?

    This is so close to what I need! Thank you for your help.

    KJP

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

    Re: Auto Populate Calendar from Table Excel

    If the dates do not show September, then perhaps you have your Excel set to manual calculation - click on the Formulas tab then on Calculation Options and set it to Automatic.

    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    09-17-2012
    Location
    Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Talking Re: Auto Populate Calendar from Table Excel

    Quote Originally Posted by Pete_UK View Post
    If the dates do not show September, then perhaps you have your Excel set to manual calculation - click on the Formulas tab then on Calculation Options and set it to Automatic.

    Hope this helps.

    Pete

    Oh my gosh it's like magic!

    Thank you - now I will tinker around with this like a grown up.

  7. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Auto Populate Calendar from Table Excel

    kjpmason,

    For your future -

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  8. #8
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Auto Populate Calendar from Table Excel

    How would you do this with 2 criteria, date and time.

    Cheers

    JD

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

    Re: Auto Populate Calendar from Table Excel

    Arlette's comment in Post #7 is still relevant. Don't hijack someone else's thread - start a new thread of your own instead.

    Pete

  10. #10
    Registered User
    Join Date
    02-26-2020
    Location
    Seattle
    MS-Off Ver
    M365
    Posts
    1

    Re: Auto Populate Calendar from Table Excel

    This is great but how can I edit it to use the current year 2020?

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

    Re: Auto Populate Calendar from Table Excel

    Again as mentioned above, you shouldn't try to hijack someone else's thread - start your own thread instead.

    In answer to your question, though, the year is chosen via a Data Validation drop-down, so if you select the cell with the year in it and then click on Data | Data Validation (twice), then you will see how the original years have been set up - just delete the ones that you don't need and add new ones at the end in the same format (separated by a comma).

    Hope this helps.

    Pete

    P.S. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    P.P.S. I've just submitted another calendar file for another user, so check that one out if you want a more modern version.

    Pete

  12. #12
    Registered User
    Join Date
    10-01-2020
    Location
    United States
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Auto Populate Calendar from Table Excel

    Pete,

    Where would I be able to find the modern version?

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

    Re: Auto Populate Calendar from Table Excel

    As with other contributors, by asking a question in someone else's thread you are deemed to be trying to hijack that thread, and this is against the Forum Rules (which you can read from the menu option at the top of the screen).

    Start your own (new) thread, and explain what you mean by "modern". There have been many variations of this calendar file over the years, so you can search the Forum for others (usually customised to suit other posters' requirements).

    Pete

  14. #14
    Registered User
    Join Date
    12-09-2020
    Location
    Paris
    MS-Off Ver
    2016
    Posts
    6

    Re: Auto Populate Calendar from Table Excel

    Dear Pete, thank you so much for this. I have a question though, what if we have an event that lasts more than one day? how can we enter a start date and end date?
    Thanks,
    Lisa

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

    Re: Auto Populate Calendar from Table Excel

    There are other versions of this calendar which allow for start and end dates for each event, and expands these automatically to have an entry for each date in the range - you just have to search for them.

    However, there are common responses above which tell posters not to post questions in other posters' threads - start your own new thread instead.

    Pete

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,883

    Re: Auto Populate Calendar from Table Excel

    Quote Originally Posted by lilou.paris.1589 View Post
    Dear Pete, thank you so much for this. I have a question though, what if we have an event that lasts more than one day? how can we enter a start date and end date?
    Thanks,
    Lisa
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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