refering to other workbooks

  • Thread starter Thread starter cjbarron5
  • Start date Start date
C

cjbarron5

I cant seem to get the referance to another workbook sheet right can anyone
help me out............im trying to make a cell = the text in another cell in
a diffrent workbook
thanks
 
The easiest way is to have both workbooks open. In the destination cell, type
the equal sign, then use the mouse to click to the other workbook and click
the source cell.
 

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

How to create absolue path link to another workbook (Excel 2003) 1
Sharing workbooks limitations - Merged Cells 12
Excel Highlighting duplicates 0
Excel VBA 0
Copy formulas to another workbook 4
Formula Audit mode active in one column only; cannot kill. 2
Merge Multiple workbook sheets into one workbook 0
Excel Protection 2

Back
Top