Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet linking
I am trying to link a cell in one worksheet (sheet 1) to a cell in another
worksheet (sheet 2). I put in = then click on sheet 1 tab, then click on the cell I want to link and press enter. The result puts me in sheet 2 in the cell I want but with the formula ='sheet 1'!A1 instead of the text that is in that cell. How do I get it to show the text from cell A1 sheet1 instead of the formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Tab/worksheet names to a worksheet cell | Excel Discussion (Misc queries) | |||
Linking data from one worksheet to another worksheet | Excel Worksheet Functions | |||
can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |