| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy pivot table and source from workbook 1 to 2. | Excel Discussion (Misc queries) | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| Copy worksheet ranges from One Workbook to another from | Excel Worksheet Functions | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Linear Mode
