using common data in multiple sapreadsheets

T

Travis

I would like to copy the results from one range of cells
in one worksheet of one workbook, to another cell in
another worksheet in another workbook, can this be done?
 
D

Dave Peterson

Sure if both workbooks are open:

workbooks("book1.xls").worksheets("sheet1").range("a1:b99").copy _
destination:=workbooks("book2.xls").worksheets("sheet2").range("c9")

If you paste to one cell, then the copy|paste command will react just like you
did it manually. It'll expand the destination range to be the same shape as the
original range.
 
Top