Dears,
I am trying to generate a workbook showing summary of progress over weeks.
The individual workbooks ( excluding summary) will be named as per the date on weekly basis. For Eg 12-5-19
19-5-19
26-5-19 etc.
All individual workbooks will have a table showing progress of items in the following format:
Structure : 50%
Finishes : 20%
MEP : 15%
In the summary workbook, there will be a table in the following format:
12-5-19 19-5-19 26-5-19 2-6-19 ... & so on
Structure : 50% 50% 50% 50%
Finishes : 20% 20% 20% 20%
MEP : 15% 15% 15% 15%
What I'm trying to achieve
In the summary workbook, I will be populating the date row manually upto the last date I require.
For the 1st week ( 12-5-19), I will update the individual file and place it in the same folder.
For the next week, I will copy 12-5-19 , rename it to 19-5-19 , update progress and place it in same folder.
After that , I need these values from 19-5-19 workbook to automatically appear in summary workbook under column "19-5-19"
And so on for all other weeks..
I cannot use VBA and would require a formula solution.
Thanks in advance..
Bookmarks