using common data in multiple sapreadsheets

  • Thread starter Thread starter Travis
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Setting Scope of name ranges to particular worksheet 2
Excel VBA 1
AVERAGE cells on another worksheet when the range is calculated 1
Excel Protection 2
Using cell as worksheet reference (macro) 1
Link behavior with changing data set 3

Back
Top