dansor
01-28-2018, 05:42 PM
I have 2000+ workbooks (A) in a folder (each having only one worksheet with data structured the same across all the workbooks). I also have another workbook (B) in a separate folder with:
The first worksheet structured the same as the 2000+ single-worksheet workbooks and
4 additional worksheets that contain formulas that refer to the data from the first worksheet.
I would like to have a macro that loops through all the 2000+ workbooks (A) and for each workbook (A):
Copies data from the single worksheet inside it
Pastes it in the first worksheet on the other workbook (B)
Saves the updated workbook (B) as workbook (C).
Is that even possible?
Thank you very much.
dansor
The first worksheet structured the same as the 2000+ single-worksheet workbooks and
4 additional worksheets that contain formulas that refer to the data from the first worksheet.
I would like to have a macro that loops through all the 2000+ workbooks (A) and for each workbook (A):
Copies data from the single worksheet inside it
Pastes it in the first worksheet on the other workbook (B)
Saves the updated workbook (B) as workbook (C).
Is that even possible?
Thank you very much.
dansor