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 How do I merge multiple worksheets in excel ?

Look here for a code example
http://www.rondebruin.nl/tips.htm

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


"rene" wrote in message ...
I am exporting data to excel, from our MRP system. Once a week, we export
this data. I need a comprehensive database to keep all the data. How do I
merge all worksheets, into one???

Originally, I had the data in access however, I exported it to .xls becuase
I thought it would be easier (silly me).