how can I move multiple worksheets into one workbook
 

I have many worksheets collected from the experiment. I want to run macro on
each worksheet and move to one workbook possibly in the order of sorted by
name of the worksheets.

Thanks.

Taek.

how can I move multiple worksheets into one workbook
 

Hi Taek

You can start here
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"cielab" wrote in message ...
I have many worksheets collected from the experiment. I want to run macro on
each worksheet and move to one workbook possibly in the order of sorted by
name of the worksheets.

Thanks.

Taek.