This time, challenge is going to be tougher. An user receives a daily sheet which has got project status and you need to prepare a consolidated worksheet for the week everyday.
1. Your sheets are named Day1, Day2.....Day7.
2. One sheet can have a maximum of 20 entries.
3. The entries may not be same everyday depending upon whether a new project has started or a project has finished.
4. You need to get all the consolidation in "Consolidated Weekly Sheet".
One typical day's sheet -
You need to write formulas (or VBA) to populate row 3 onwards
A typical answer would look like -
The worksheet related to this challenge can be downloaded from Challenge 43 - Consolidate Daily Sheets into a Weekly Sheet
The answer to the above challenge will be published after a month i.e. on 21-Jun-16.