Consolidating spreadsheets
Does anyone have an easy code to consolidate all workbooks within a
specified folder?
Create new workbook
Get contents of workbook1
Paste into new workbook
Get contents of workbook2
Paste under contents of workbook 1 in new workbook
Get contents of workbook3....
Until there are no more workbooks in that folder.
|