Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells with text to each other
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells with text to each other
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 Visual Calendar Dilemma wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing cells that contain numbers and text | Excel Discussion (Misc queries) | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) |