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