Hi Lois
Do you want to do it with code ?
See
http://www.rondebruin.nl/copy1.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Lois" wrote in message ...
hi
i have 2 worksheets, when a new row of information is added to 1 worksheet,
some of the details need to be transfered unto the next blank row of other.
Is there any way i can do this ?
--
Lois