OK, i have tried to take my activity list in Inventory Tab and insert activity name in the appropriate Start & End Day in the interactive calendar that i pulled from Microsoft Template
My inventory list is long and i want to keep the built in functionality of the "Any Year One Month Calendar", but include my activity list "Activity Name + "Start" on start date, and "Activity Name + End in the appropriate day
I have made room for multiple activities on the same day.
Is this possible without VBA? or Only VBA can do this
any thoughts
This is the Template found in Excel "Any Year One Month Calendar" with plenty of Named Ranges and its own interactive formulas.
My inventory list is long and i want to keep the built in functionality of the "Any Year One Month Calendar", but include my activity list "Activity Name + "Start" on start date, and "Activity Name + End in the appropriate day
I have made room for multiple activities on the same day.
Is this possible without VBA? or Only VBA can do this
any thoughts
Name | Start Date | End Date |
Activity1 | 5/01/23 | 5/15/23 |
Activity2 | 1/01/23 | 6/15/23 |
Activity3 | ||
Activity4 | ||
Activity5 | ||
Activity6 | ||
Activity7 | ||
Activity8 | ||
Activity9 | ||
Activity10 | ||
Activity11 | ||
Activity12 | ||
Activity13 | ||
Activity14 | ||
Activity15 | ||
Activity16 | ||
Activity17 | ||
Activity18 | ||
This is the Template found in Excel "Any Year One Month Calendar" with plenty of Named Ranges and its own interactive formulas.
2023 | MAY | MONDAY | ||||
CALENDAR YEAR | CALENDAR MONTH | FIRST DAY OF WEEK | ||||
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
01 | 02 | 03 | 04 | 05 | 06 | 07 |
Activity1 - Start | ||||||
08 | 09 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
Activity1 - End | ||||||
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 | 01 | 02 | 03 | 04 |
05 | 06 | 07 | 08 | 09 | 10 | 11 |