Gathering Info on one sheet
 

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

Gathering Info on one sheet
 

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