Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reference-one cell to another
I would like to set a function for a cell,that displays the cell on another
page. |
#2
|
|||
|
|||
Hi Heath
if you mean that you want cell A27 on sheet 2 to display what ever is in A3 on sheet 1, the "easiest" way to do it is click in cell A27 on sheet 2, type an = then click on A3 on sheet 1 and press enter. The formula =Sheet1!A27 will be put into the cell for you. You could, of course, just type this yourself. However, you need to remember, if the sheet name contains spaces you need to put ' ' around the sheet name, e.g. ='Jan Figs'!A27 Regards JulieD "Heath" wrote in message ... I would like to set a function for a cell,that displays the cell on another page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |