View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jess[_2_] Jess[_2_] is offline
external usenet poster
 
Posts: 11
Default 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.