+ Reply to Thread
Results 1 to 4 of 4

Auto populate events to excel calendar from a list

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Auto populate events to excel calendar from a list

    I need help, please. I have a spreadsheet with a monthly calendar (Columns A - G). Each month is on a separate tab. to the right of each calendar (Columns i - K) there are 3 columns of data (Date, Type, Description) I'm trying to auto populate data from the "Type" column (J) into the calendar that is on the same sheet. There are times when there will be 2 - 4 types on the same day so the formula will need to populate all of them on the same day. Does anyone know of the formula that will work?

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

    Re: Auto populate events to excel calendar from a list

    See if this thread gives you some ideas:

    http://www.excelforum.com/excel-gene...-on-excel.html

    With my calendar generators I tend to have one sheet for ALL activities, which can be listed in any order, and one sheet for a monthly calendar where you can select the month and year from drop-downs. The one pointed to in my first post in that thread will display up to 7 activities on any one day, but later in the thread I give the capability to display up to 10 in ranges of 10.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-21-2016
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: Auto populate events to excel calendar from a list

    Thank you for the reply, Pete. I did see the posts you mentioned. I do need to have the calendar and the data all on one sheet as in the example image posted by RazedC in the first post. Each month of this calendar will be on a separate tab with the data for each month on the same tab as the calendar. Is there a formula to auto populate the data onto the calendar that is on the same sheet? There will be days where there are more than one event so it will need to populate all of them. I've been struggling with this for weeks. Any help you can give would be greatly appreciated.

    Thanks.

  4. #4
    Registered User
    Join Date
    01-21-2016
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: Auto populate events to excel calendar from a list

    Good afternoon, Pete. Just wanted to let you know that I was able to figure it out using the formula from one of the templates. I'm all set. Thank you for your assistance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Populate a Linear Calendar Based On A List With Date Ranges
    By falafelologist in forum Excel General
    Replies: 3
    Last Post: 05-20-2015, 08:15 PM
  2. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  3. Auto populate events in calendar on userform
    By imzhakmaya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 07:31 AM
  4. Need help with auto-populate list schedule details to calendar, please.
    By aghamilton327 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2014, 03:20 PM
  5. Auto populate excel calendar
    By sccrmania527 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-10-2014, 12:12 PM
  6. [SOLVED] Auto-populate calendar using data list
    By myexcelquestions in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 08:58 PM
  7. Can't Auto Populate Excel Calendar
    By svjennings in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2011, 11:49 AM

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