merging multiple files/sheets into one
 

I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each
file has the same sheet in it but with different data. Do not have to
worry about data overwriting. I have seen something like this before
but can not remember how to do it with VBA.

Thanks!

merging multiple files/sheets into one
 

Hi Stephen

See this page
http://www.rondebruin.nl/copy3.htm


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



wrote in message ups.com...
I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each
file has the same sheet in it but with different data. Do not have to
worry about data overwriting. I have seen something like this before
but can not remember how to do it with VBA.

Thanks!

merging multiple files/sheets into one
 

You can give this a look...

http://www.rondebruin.nl/summary2.htm
--
HTH...

Jim Thomlinson


" wrote:

I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each
file has the same sheet in it but with different data. Do not have to
worry about data overwriting. I have seen something like this before
but can not remember how to do it with VBA.

Thanks!