| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste - Workbook to Workbook
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste - Workbook to Workbook
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste - Workbook to Workbook
Ron,
Thank you! How do save file name for Workbook 2 to a variable? Dwight "Ron de Bruin" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste - Workbook to Workbook
If you copy the code in your personal.xls you can run the code
for the workbook that is active (No need to know the name) You must change this line Set SourceRange = ThisWorkbook.Sheets("Sheet1").Range("A1:K1") To this for the range on the activesheet Set SourceRange = Range("A1:K1") See this page how you can copy the code in your personal file so you can use the macro for any activeworkbook. http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dwight" wrote in message ... Ron, Thank you! How do save file name for Workbook 2 to a variable? Dwight "Ron de Bruin" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
| automate copy and paste whole workbook to new workbook | Excel Programming | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Hybrid Mode
