Good day
Please refer to the attached.
I have a calander where appointments are updated on the "Data" sheet.
I need to populate the info (as listed "Events, etc." ) to the "Full" sheet based on the date selected on the Calander.
There is already a Macro to create the "selectedCell" which if you click a date will populate in B4 on the "Full" sheet.
I tried a VLOOKUP but this will only gives me one event based on the date, I need to see at least 13 events pull accross based on the formula. I tried "Match" and "Index" but not an expert with these formulas
Please assist
Bookmarks