+ Reply to Thread
Results 1 to 5 of 5

Autopopulate dates from table to monthly calendar

  1. 10-24-2017, 04:37 PM #1
    emjean11
    emjean11 is offline
    Registered User
    Join Date
    10-24-2017
    Location
    Cleveland, Ohio
    MS-Off Ver
    Microsoft 2011
    Posts
    3

    Autopopulate dates from table to monthly calendar

    I'm trying to create a calendar in excel that will autopopulate the dates (deadlines) from a table i've created that will show them on a monthly calendar using a title i've assigned the date from the same row. I downloaded a template and am trying to use it as a starting point but I'm running into some issues and wondering if anyone can help me out? It's not letting me attach the actual excel doc but i did attach some pics.calendar_test.xlsxScreen Shot 2017-10-24 at 4.35.27 PM.pngScreen Shot 2017-10-24 at 4.35.35 PM.png
    Reply With QuoteRegister To Reply
  2. 10-25-2017, 09:31 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Autopopulate dates from table to monthly calendar

    What is the issue? You have formulas in the monthly view that show the message "Assignment Due!" if there are any items in the assignment list with the corresponding date. Seems to be what you intended.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 10-25-2017, 09:37 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Autopopulate dates from table to monthly calendar

    Is this what you are after?

    =IF(LEN(E12)=0,"",IFERROR(INDEX(Assignments[Description],MATCH(E12,Assignments!$D$4:$D$15,0)),""))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 10-25-2017, 09:42 AM #4
    emjean11
    emjean11 is offline
    Registered User
    Join Date
    10-24-2017
    Location
    Cleveland, Ohio
    MS-Off Ver
    Microsoft 2011
    Posts
    3

    Re: Autopopulate dates from table to monthly calendar

    I'm trying to have the calendar autopopulate with combined data from the same row. See image attached.
    Screen Shot 2017-10-25 at 9.41.08 AM.png

    Quote Originally Posted by 6StringJazzer View Post
    What is the issue? You have formulas in the monthly view that show the message "Assignment Due!" if there are any items in the assignment list with the corresponding date. Seems to be what you intended.
    Last edited by emjean11; 10-25-2017 at 10:11 AM.
    Reply With QuoteRegister To Reply
  5. 10-25-2017, 10:08 AM #5
    emjean11
    emjean11 is offline
    Registered User
    Join Date
    10-24-2017
    Location
    Cleveland, Ohio
    MS-Off Ver
    Microsoft 2011
    Posts
    3

    Re: Autopopulate dates from table to monthly calendar

    When I plug that in to my calendar it's not doing anything. the calendar is blank.

    Quote Originally Posted by AliGW View Post
    Is this what you are after?

    =IF(LEN(E12)=0,"",IFERROR(INDEX(Assignments[Description],MATCH(E12,Assignments!$D$4:$D$15,0)),""))
    Last edited by emjean11; 10-25-2017 at 10:10 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Monthly Calendar limited to month dates only
    By GgRee in forum Excel General
    Replies: 2
    Last Post: 05-02-2017, 03:04 PM
  2. [SOLVED] Autopopulate Excel Calendar with Data Ranges
    By hlmmc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2016, 07:50 PM
  3. [SOLVED] How to autopopulate calendar with data from different sheet
    By marcella needs help in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2016, 06:07 AM
  4. Monthly spreadsheet autopopulate master sheet?
    By sahsonk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2015, 01:52 PM
  5. Populate monthly calendar with table
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-08-2014, 04:18 AM
  6. To-do list and calendar - Fill in monthly calendar with dates of to-do table
    By gjrr4x1 in forum Excel General
    Replies: 3
    Last Post: 07-29-2014, 01:20 PM
  7. Monthly parts ordering form, autopopulate based on calendar month and lead times
    By ladydubs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2012, 02:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1