Hopefully this will make sense.... I am looking to populate a seasonal calendar based on 2 lists of dates (events and camps).
I have two separate lists of dates in my sample file
Events- cells AA:AD
Camp- cells AF:AH
I need to populate rows 18-24 for Events and 25-31 for Camps based on it correlating to the dates in the rows above (row10-16 in red) ** this are just reference cells and not sure if they are needed. In row one there is a start date for the calendar that I am using to easily change the dates highlighted in red in order to make it easier to update the file form year to year. Is there a better way to reference the dates?
I have a sample entries in column H and I, based on my data entered in events and camp list the actual data will end up being entered in column L to Q
Bookmarks