How do I combining several worksheets onto one

[iamoktc]

I have 17 seperate worksheets in one book. I now want to combine all that
information, which is in identical format, onto one worksheet.

 

[Ron de Bruin]

Hi iamoktc

Try this code example
http://www.rondebruin.nl/copy2.htm

 

[Bernard Liengme]

Do a Google with search term <excel consolidate>
Then, if needed, come back but tell us more about the layout of the
worksheets.
best wishes

 

[Gord Dibben]

See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy2.htm


Gord Dibben MS Excel MVP