Hi albertmb

See this page for a code example
http://www.rondebruin.nl/copy2.htm

--

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


"albertmb" wrote in message ...
Hi everyone,

I have this problem: info is entered in 12 sheets (representing a sheet for
each month). The amount of rows used can not be determened beforehand, i.e.
on sheet1 I might use 300 rows and on Sheet2 I might use 400. But the colomns
are identical on each sheet.
Is it possible to gather the information from all twelve sheets in one sheet?

Thank you