how can i import worksheets from multiple workbooks

D

davidp23

Hi,
I have a bunch of workbooks that all used the same template and were filled
out for each week of the year. They all have a "totals" sheet the collects
all the important data within.
What i want to do is create a macro that imports that totals page, or a
section of it from a bunch of these different workbooks, say all the ones in
january or maybe the entire years worth so i can do some more analysis. my
VBA skills are terrible but i am learning slowly. Any help would be
appreciated.
 

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

Linking workbook to multiple worksheets 1
How do I find like data in multiple worksheets? 1
Dsum and Dmax with structured references 1
formula problem in grouped worksheets 1
How to update a value from a linked worksheet back to the master worksheet? 0
deleting workbooks as i go 4
Sum data from multiple Workbooks. 1
Problem with formula in grouped sheets 2

Top