Avatar of EnigmaMatter
Flag for United States of America

asked on 

Consolidation of Workbooks


I have 10 to 300 reports in any given month in a folder at C:\Users\FakeUserName\Repository.

Each report has a page called "ImportData".

On ImportData Sheet, there is 1-5 rows of data.

Is there a script that will open each workbook individually in the aforementioned folder, copy the data on ImportSheet into a new workbook titled "Master Import File" on the Desktop, and then close the original workbook? Rinse and repeat for each workbook in the folder?
Microsoft ExcelVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon