Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you link cells containing text?
I am trying to link cells so that when I enter text into one cell, it is
displayed in another cell. I am using Excel 2003, and I want to be able to have a series of cells linked so that when one displays a certain text (no matter what the others are displaying), a cell on a different page shows that text. (I am using 'ticks' and 'crosses') Any help would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you link cells containing text?
Assuming you enter text on Sheet1 A1 and you want to link to Sheet2 F1
In Sheet2 F1=Sheet1!A1 "Getting desperate!!!" wrote: I am trying to link cells so that when I enter text into one cell, it is displayed in another cell. I am using Excel 2003, and I want to be able to have a series of cells linked so that when one displays a certain text (no matter what the others are displaying), a cell on a different page shows that text. (I am using 'ticks' and 'crosses') Any help would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
How can I fill a series in Nonadjacent cells eg Text 1, Text 2 | Excel Discussion (Misc queries) | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) |