Ok question for you... Ive been reading through your tutorial and been
playing around implementing it into my master record. Few questions.
The header on each page goes from Cell A1:F1, A2:F2, & A3:F3. So the
actual data doesnt start till A4:F4. So how do i set it to only start
copying the information from A4:F4 and beyond all the way down to the
bottom of the page wether it be A100:F100 or A500:F500.

Then it needs to start inserting the data into field A4 on the master.

Your help is appreciated.

wmureports wrote:
Thanks Ron, Ill check it out and let you know how it goes.


Ron de Bruin wrote:
Hi wmureports

Start here
http://www.rondebruin.nl/copy3.htm

Post back if you need more help


--
Regards Ron De Bruin
http://www.rondebruin.nl



"wmureports" wrote in message oups.com...
Heres my goal. I have a directory full of .xls files, around 500 or
so. I would like to
merge all these files (all located in c:\data) into one master file.
Doing
this through a macro would be prefered because importing each file
individually would take about 2 months to complete :)

All XLS files are the same. The formating in all 500 xls files are
identical. The only thing that varies is the data held with-in. The
columns and what not are the same. They just hold information for
specific dates. And I want to make one master that combines all the
information from the past 2 years into one XLS file.

Any help with this? Im new to macro's and dont really know where to
start :(