The goal is to track all projects (Column A) that have been updated weekly, based on the “project modified date” in Column D. Each week the range will change. For this current file assume the range starts from Saturday February 23 through March 1st (Fiscal Week 9).
Consolidate totals by project name prefix: CO, GA, HI, MAS, National, NCAL, NW, OH, SCAL, CD, CS, HP, OR, TPMO, Wrapper
Please use a separate tab to show the results summary by prefix
I would like to see the results mapped to the PPT file, so that the data that is captured in the results tab, automatically updates the “current” data in the PPT file.
Note: Attached is a copy of a similar Excel file and PowerPoint as a guide although, the data being displayed is different.