Consolidating spreadsheets

J

Jess

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from workbook 2 to workbook 3 mystery! 2
Consolidating data from several sources to one target book 5
Unwanted workbooks on startup 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
list Workbooks in Current Folder 4
Getting the workbook number via VBA code 2
Perform code on all (closed) workbooks scattered across sub-folders of common parent folder 6
combo box multiple workbooks / sheets 3

Top