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

--
Message posted from http://www.ExcelForum.com

Hi Jayhawktc

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


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


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

Thanks,


---
Message posted from http://www.ExcelForum.com/

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" wrote in message
...
Hi Jayhawktc

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


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


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

Thanks,


---
Message posted from http://www.ExcelForum.com/

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

"Paul Lautman" wrote in message
...
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" wrote in message
...
Hi Jayhawktc

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


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


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

Thanks,


---
Message posted from http://www.ExcelForum.com/

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


"Paul Lautman" wrote in message ...
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" wrote in message
...
Hi Jayhawktc

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


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


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

Thanks,


---
Message posted from http://www.ExcelForum.com/