Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatically place text in one cell into cell in another sheet
I am having problems working out how to automatically place text from one
cell into a cell in another sheet. I have read the post on 10 April 07 "Repeat text in exact cells in multi-worksheets" and tried the solution: "select the cell in question in the 2nd sheet, type an equal sign, then click the 1st sheet tab and the cell where you want to link to, then press enter. " When I do this, I get the formula showing up in the cell to be copied to (in my sheet the formula is: =People!B2 but the actual text in the cell to be copied doesn't appear. I can't work out what is going on - can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I place 3 lines of text (an address) in 1 cell? | New Users to Excel | |||
place text in one cell | Excel Worksheet Functions | |||
Why am I seeing ###### in place of text within the cell? | Excel Discussion (Misc queries) | |||
Is there a formula that will place the sheet name in a cell? | Excel Worksheet Functions | |||
Can I place visible text in cell that won't print | Excel Discussion (Misc queries) |