Multiple Worksheets

[John McG]

Hi

Anyone out there who can tell me an easy way to export Excel data in multiple worksheets?

I have a workbook with about 80 worksheets that are identical informat. I am trying to export the data to Access or move the data to a single worksheet in Excel.

Any tips? Sources of info? Help files? I can't find anything on the subject.

And thank you for your support.

JMcG

 

[Ron de Bruin]

Hi John

For a single worksheet try this
http://www.rondebruin.nl/copy2.htm

For Access look here
http://www.erlandsendata.no/english/index.php?t=envbadac


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

Hi

Anyone out there who can tell me an easy way to export Excel data in multiple worksheets?

I have a workbook with about 80 worksheets that are identical informat. I am trying to export the data to Access or move the data

to a single worksheet in Excel.