+ Reply to Thread
Results 1 to 2 of 2

I want to populate information to a calendar from a list within a table on a separate tab

  1. #1
    Registered User
    Join Date
    04-07-2021
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Office 16
    Posts
    1

    Post I want to populate information to a calendar from a list within a table on a separate tab

    I have an excel workbook that I would like to use to track several due dates. I have one setup for my family and I have one setup for my work projects. I have already made a query to create a master table of all events. I want that table to populate the calendar on the correct date with the model (missed changing this header when I switched it over from my work version, lol) and description. Any help with the formula to make this happen would be greatly appreciated! Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,397

    Re: I want to populate information to a calendar from a list within a table on a separate

    Here is an example developed by "Pete_UK"

    In your calendar I had "#Values" in the April sheet. I used the following B6 and copy across

    =IF(WEEKDAY(DATE(MoYear,MONTH(MoMonth&0),1))=COLUMN(A$2),1,IF(LEN(A6)>0,A6+1,""))
    Attached Files Attached Files

+ 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. Replies: 7
    Last Post: 01-20-2019, 06:28 PM
  2. Replies: 1
    Last Post: 01-11-2019, 09:05 PM
  3. [SOLVED] Use 2 separate rows to populate data in a separate table....
    By Sbenn316 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2017, 11:38 AM
  4. Populate a calendar from a table
    By jfk1400ny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2016, 09:46 AM
  5. [SOLVED] Populate a calendar from a table
    By Gerard.GRC in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-05-2015, 11:53 PM
  6. 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
  7. Replies: 3
    Last Post: 07-29-2014, 01:20 PM

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