How do I refer to cell in another worksheet in a formula

J

Jim

I am trying to operate on a data element in one worksheet that is contained
in another worksheet.
 
H

Harry Hockenlocker

Assuming that you can see the other worksheet (it's open on your computer)
1. place the cursor where you want to see the data from the other worksheet, then
2. press the = sign
3. go to the cell with the data in the other worksheet and
4. click on it
5. press enter

Would suggest putting the two separate Excel files in a single folder first and then keep them together so they will find each other when opened again. Which is why in any single workbook you can have up to 256 separate worksheets... another option.
 

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

Drop down list control value in vba 2
offset formula causing Circular reference 0
Syncing between source worksheet and dependent worksheets 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Embed the same Excel multiple times 0
Worksheet relative reference 3
how do I referance a data valuation cell from another worksheet 2
Multiply with Vlookup value from another Worksheet 0

Top