I have a ROOT folder wih many subfolders
In each subfolder there is a xls file with a name which begins with “report” char.
Every file contains a sheet with the following name “portfolio”.
I also have a Portfolio.xls in the ROOT folder.
I need a VB script / Bat or VBA which do the following.
Open Portfolio.xls (placed at ROOT folder)
Select Portfolio sheet.
Copy data without header from Portfolio sheet (this file contains only one sheet with exactly the same number of columns of portfolio sheet placed in every report.xls
Open sequentially every report_xxxx.xls report placed at subfolder 1, subfolder 2, etc…
Select Portfolio sheet, reset data without the header and copy the data from Portfolio sheet placed at root folder.
Thank you very much for your help.