Linking cells with text to each other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I think my question is best described with an Example.

I have cell A1 on Sheet1 (cell currently is blank/empty) that I would like
to link to cell B1 on Sheet2 (cell contains the word CAT).

I go to A1 on Sheet1 and type an = in the function tool bar then I select B1
on Sheet2 and the word CAT appears in A1 on Sheet1. Perfect that is what I
want, however, if I change the word in B1 on Sheet2 to DOG, the word does not
change in A1 on Sheet1. Why not? I want it to, how do I do this?
 
Press the F9 key - if the cell does change then you have the sheet
calculation mode set to manual rather than automatic. Go to Tools |
Options | Calculation tab and rectify here.

Hope this helps.

Pete
 
You must log in or register to reply here.

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

add hyperlink using sheet names and cells(i,j) 3
Cell highlighting question 4
check value in cell 2
Cell Reference 1
display a value from Sheet1-A1:A10 in Sheet2-B1 2
if statement, change cell only if true 4
Variable reference in a function 3
Copy non merged to merged cells again 1

Back
Top