Thread: merging multiple files/sheets into one
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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!



Reply With QuoteReply With Quote