Apr 06 2021 10:17 AM
I have several work projects going on currently with varying due dates.
I would like to create a workbook with separate tabs for each project.
Each tab would be in the same format & contain the "event name", the date it is due and then an area for notes (ideally).
I would then like for the information from each of these tabs to auto-populate into a master calendar.
Any help or advice I can get on making this happen would be GREATLY appreciated!
Apr 06 2021 11:58 AM
https://templates.office.com/en-us/Search/results?query=Project+Planer
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Apr 07 2021 08:04 AM
I have looked through several templates and haven't found one to meet my needs.
Are you aware of a template that allows you to enter detailed data into multiple tabs and then compiles the due dates listed on those tabs into one main calendar?
Thanks!
Apr 07 2021 09:00 AM
Apr 09 2021 05:19 AM
@NikolinoDE This is an example of what I am working on. I took the workbook that I created to organize my work projects and converted is over for my family to use. The concept is the same a tab for each person/project with a standard way to list activity data. I went ahead and created a query to convert these into a single worksheet, hoping that would make this task a little easier. I'm just having issues with the right formula to get the right data onto the calendar. I would prefer it if it would list the person/project name and the description on the corresponding day. My workbook for my work projects I already have the conditional formatting setup to color coordinate based on the model name posting on the calendar. Thank you for the help!
Apr 12 2021 08:36 AM