Multiple Workbooks

G

Guest

I have multiple workbooks each of which contains a great deal of data that is
summarized on a single sheet within each workbook. I am trying to
consolidate each of these "summary" sheets into a single seperate workbook.
I have structured the workbooks into directories within windows and would
like to build a macro that will be able to open every workbook in the
directory (one at a time) and copy the sheet I need into my new workbook .
Any thoughts?

Oh yeah each workbook has a different name and each directory has a
different number of workbooks.
 

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 cell value from one worksheet to matching worksheet in another workbook 4
Copy data into multiple workbooks 1
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Copy all workbooks into one workbook 5
Save specific sheets to new workbooks adding tomorrow's date to na 1
Running formulas with data from mulitple workbooks 2
New Loop, 2 workbooks 3
VBA macro guru help needed! 1

Top