Thread: automate a cut and paste of data from one work book to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote