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

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

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