VBA Excel Data Consolidation (2 Sheets)
Budget: $10 – $30 USD
In the zipped folder, it contains
- sample of 2 months dummy data
- each file contain IND and ENT sheets, some files may only contain either or
- "consolidate" excel file is the sample outcome for reference
The VBA should work as per below
- an input to insert month (free text) e.g. 202301, 202302 etc
- choose destination folder and files (in some of the months it contain unnecessary files)
- IND sheet to consolidate only IND data from selected files
- ENT sheet to consolidate only ENT data from selected files
- 'Summary' sheet to provide number of rows overview for both
Challenge
- whether consolidation outcome can be done in 1 excel
- whether it would work with a password encrypted files (please advice any workaround)
- sample of 2 months dummy data
- each file contain IND and ENT sheets, some files may only contain either or
- "consolidate" excel file is the sample outcome for reference
The VBA should work as per below
- an input to insert month (free text) e.g. 202301, 202302 etc
- choose destination folder and files (in some of the months it contain unnecessary files)
- IND sheet to consolidate only IND data from selected files
- ENT sheet to consolidate only ENT data from selected files
- 'Summary' sheet to provide number of rows overview for both
Challenge
- whether consolidation outcome can be done in 1 excel
- whether it would work with a password encrypted files (please advice any workaround)