Multiple Worksheet copying to a master worksheet

[Jayhawktc]

I am in need a macro that will take data of varying length and copy i
to a master worksheet. The information needs to be copied and the
pasted below the previous one on the master sheet so that I can compil
all the information on one sheet. The data on each sheet is always th
same amount of columns but the number of rows will vary. Any help wit
this is greatly appreciated.

Thanks

 

[Ron de Bruin]

Hi Jayhawktc

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

 

[Paul Lautman]

Try coupling Ron's code with the lastcell() function at
http://www.beyondtechnology.com/geeks012.shtml

to reliably obtain the last used row on the page.

Hi Jayhawktc

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

 

[Paul Lautman]

Forget that, he already has a version there !!!

Try coupling Ron's code with the lastcell() function at
http://www.beyondtechnology.com/geeks012.shtml

to reliably obtain the last used row on the page.

 

[Ron de Bruin]

Hi Paul

I use a function that find the last used row in the sheet already
See the code

--
Regards Ron de Bruin
http://www.rondebruin.nl

Try coupling Ron's code with the lastcell() function at
http://www.beyondtechnology.com/geeks012.shtml

to reliably obtain the last used row on the page.