Situation:
requirement:
- various branches send weekly data to myself in specific excel template BWH (branch weekly highlights)
- all the incoming BWH files have a sheet named "ExportData" (protected with pwd "ADMIN") with identical table structure. the difference is the number of records. i have provided a filter to filter only applicable records and hide the blank rows.
- i have to compile the data from various branches into one single file WHM (weekly highlights master). the table structure in the WHM is also identical.
requirement:
- in the BWH templates, i have to load a vba code which would push the filtered records to my WHM in my C:
- the data from various branches would get pasted (append) as values in blank rows.
- the WHM would be used to collect the data for one year.