Copy Row of One Workbook to Next Available Row of a Second Workbook
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" |
Copy Row of One Workbook to Next Available Row of a Second Workbook
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" |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com