| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate a cut and paste of data from one work book to another
I wish to automate the cut and past from a 12 month budget Excel spread sheet
from one workbook to another by formular or a macro. Can anybody help please -- Andy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automate a cut and paste of data from one work book to another
Try something like the following. Change the workbook names,
sheet names, and ranges to meet your needs. Workbooks("OldFile.xls").Worksheets("Sheet1").Rang e("A1:A10").Copy _ Destination:=Workbooks("NewFile.xls").Worksheets(" Sheet1").Range("A1") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ian Anderson" wrote in message ... I wish to automate the cut and past from a 12 month budget Excel spread sheet from one workbook to another by formular or a macro. Can anybody help please -- Andy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automate a cut and paste of data from one work book to another
If you do I'll send you a excel file with a macro doing what i understood. See the green square code. -- jormonal ------------------------------------------------------------------------ jormonal's Profile: http://www.excelforum.com/member.php...o&userid=34949 View this thread: http://www.excelforum.com/showthread...hreadid=546521 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
