I am attaching my workbook for reference.
The first five worksheets (with dates) is the information that I manually enter every workday - for each of the 12 indicators in these worksheets. In the following worksheets, I am grouping the previous information by indicator (as found on the date worksheets). On the indicator worksheets, the second page (summary table and charts) are auto-populating, and working great. The first page on these work sheets, however, I am not sure how to organize. This large table is a monthly summary for the 4 people - one for each indicator. Is it possible to have this table automatically fill based on what is manually entered on the Date (original) worksheets? Since the first of the month will be a different day of the week, it's not as simple as just setting up conditional formatting. I would like to have each day of the month, and have the colour code reflect the appropriate day of the month on the date worksheet, plus black fill and no text for weekends.
I'm not sure if I am being clear enough on my description of the desired end-state.
I have no problem adding extra helper columns or tables, or anything it would take.
Thanks in advance for your help!
Colin
Bookmarks