Thanks, for the source range & dest sheet do i need to type in the full file
path or just the workbook names?
--
Lois


"Ron de Bruin" wrote:

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