How do I merge multiple worksheets in excel ?
 

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).

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).