Hi Dwight

Start here
http://www.rondebruin.nl/copy1.htm

The last example on the page will use a different workbook


--

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


"Dwight" wrote in message ...
I am looking for a way to copy a row of information from one workbook to
another.

A user sends their Workbook to us (Workbook 2). We open it and copy his/her
information in row 2 to the Master.xls

Workbook 1 file name is Master.xls
Workbook 2 file name changes

Need to copy row 2 from Workbook 2 to the next available row in Workbook 1
then save and close Workbook 1.

Thanks in advance!

Dwight