Merging worksheets in a workbook

sheilahughes98 · Mar 22, 2004

I have 200+ workbooks, each with 3 sheets. I need all the
information for each workbook on 1 worksheet. Can anyone
advise?

TIA

Frank Kabel · Mar 22, 2004

Hi
have a look at the following site as a starting point
http://www.rondebruin.nl/copy3.htm

Ron de Bruin · Mar 22, 2004

Hi Frank

She posted this in Misc

but I'm afraid I don't use VB

I ask here wy?
Maybe she think she need Visual Basic?

Frank Kabel · Mar 22, 2004

Hi ron
just saw your reply to her in Excel.misc. Interested in her response