I have a scenerio where we want to make 6 regional workbooks that contain
customer contact info and other key data. We want to have a "master" book
that contains the national data. We would like to find a way to automate
this.

In summary, we are looking for a method to merge the entire contents of 6
regional workbooks (only one 1 worksheet per book) into one "master" workbook.
We are using Excel 2000.

Any suggestions?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200603/1