+ Reply to Thread
Results 1 to 2 of 2

Insert event in calendar according to list

  1. #1
    Registered User
    Join Date
    03-30-2017
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    54

    Insert event in calendar according to list

    Hi everyone!
    I am creating a calendar and appointment sheet.
    Basically it will be possible to insert up to 4 events on each day of the month.
    I would like to list the events in a side list (by date and name of the appointment) and that event should be listed on the respective day in my calendar.

    Capturar.png

    I've already managed to create my dynamic calendar, where the dates change according to the month and year selected in cells Q1 and S1.
    However, I have not yet been able to automatically list appointments on the calendar as they are added to my list.

    I tried some combinations with the Index function, but was unsuccessful.
    Attached is the spreadsheet I am developing

    Can anybody help me? Is there any way to do this without using matrix formulas?

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-30-2017
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    54

    Re: Insert event in calendar according to list

    Solved with the formula below:

    =IFERROR(IF(MOD(ROW(),4)+1=1,INDEX($T$5:$T$99,MATCH(B4,$S$5:$S$99,0)),INDEX($T$5:$T$99,AGGREGATE(15,6,ROW($S$5:$S$99)-ROW($S$4)/($S$5:$S$99=MAX(B1:B4)),MOD(ROW(),4)+1))),"")

+ 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: 1
    Last Post: 04-07-2020, 07:26 AM
  2. Event Calendar from a List with Links and Bars
    By msozturk07 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2020, 03:59 AM
  3. [SOLVED] Insert Dropdown List inside Calendar Days
    By 323100N in forum Excel Programming / VBA / Macros
    Replies: 98
    Last Post: 05-24-2018, 03:32 AM
  4. Calendar - Inset event
    By BRENDOW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2017, 10:10 AM
  5. Event calendar with recurring event
    By glnorton in forum Excel General
    Replies: 2
    Last Post: 11-05-2014, 04:42 PM
  6. Event Calendar - Recurring event and filter
    By glnorton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-01-2014, 07:57 PM
  7. how to insert a calendar list and or oricon
    By od in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 05:35 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