Forum Discussion
Excel Calendar populated information from other tabs
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!