Daily Task Excel (2016) File Consolidation with VBA solution
Budget: $10 – $30 USD
We have reports generated automatically on daily basis (i have attached a sample for one day 01/01/2024). You may create other days till end of month by changing the alphabets in "Work ID" accordingly.
The aim is to consolidate all the days automatically, with the following conditions.
- flexibility to choose which date (i may be asked to focus on certain dates only)
- to consolidate only Work Status : Completed
- to choose which Work Type accordingly (i could just add/minus in the script itself, as we have LOB 1, LOB 2 etc)
- once consolidated, there is need to remove duplicates on Work ID as some cases were added accidently from previous day
The aim is to consolidate all the days automatically, with the following conditions.
- flexibility to choose which date (i may be asked to focus on certain dates only)
- to consolidate only Work Status : Completed
- to choose which Work Type accordingly (i could just add/minus in the script itself, as we have LOB 1, LOB 2 etc)
- once consolidated, there is need to remove duplicates on Work ID as some cases were added accidently from previous day