Transfer Information

[Lois]

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 ?

 

[Ron de Bruin]

Hi Lois

If you want to copy to another workbook see this example
"What if the Database sheet is in another workbook"




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

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