Merging workbooks
 

I have a year worth of data in at least 8 folders. Each folder contains at
least 10 files with in each doc there maybe up to 20 tabs of data. They all
have the same heading. Can I get a step by step way to merge this into 1
tangible document that can be read for an end of year type of doc for
research purposes?

Merging workbooks
 

Hi

Go to Ron de Bruin's site for sample code to show you how to merge data from
many files.
http://www.rondebruin.nl/tips.htm

--
Regards
Roger Govier

"LG" wrote in message
...
I have a year worth of data in at least 8 folders. Each folder contains
at
least 10 files with in each doc there maybe up to 20 tabs of data. They
all
have the same heading. Can I get a step by step way to merge this into 1
tangible document that can be read for an end of year type of doc for
research purposes?