Forum Discussion
Excel Calendar populated information from other tabs
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)
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!
- JodelleDeanApr 12, 2021Copper ContributorStill looking for a formula to solve my issue of transferring the condensed data over to the calendar. Any help would be greatly appreciated.