See Ron de Bruin's code for this.

http://www.rondebruin.nl/copy1.htm#workbook


Gord Dibben MS Excel MVP

On 13 Nov 2006 21:12:44 -0800, wrote:

Ok I have two sheets, one creates a quote, the second is a report sheet
of that quote.

What I need is for the workbook "Quotinator" to copy cells in sheet
"report" a2:z2 into a the next available row in a workbook saved at
t:\quote report\quote report.xls and the sheet called "database"