| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Lou
In C1 on sheet1 you have =A1+B1 In any cell on sheet2 you enter =sheet1!C1 Or go to a cell on sheet2 and type an = sign, then swithch to sheet1. Select C1 and hit the <ENTER key. Or copy sheet1 C1 and switch to sheet2. Select a cell then Paste SpecialPaste Link Gord Dibben Excel MVP On Sun, 28 Nov 2004 15:31:02 -0800, Lou wrote: I am trying to diplay the answer from a fomula on one page to another so that i don't have to have the same formula twice..i keep getting an error....Please help...Lou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
| How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Threaded Mode
