| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use cell a5 on sheet 1 in cell c10 on sheet 2
I want to be able to use a cell on sheet 1 on another cell in a different
sheet but within the same workbook. Example use a5 on sheet 1 in cell c10 on sheet 2. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use cell a5 on sheet 1 in cell c10 on sheet 2
In cell Sheet2C10 put this formula..........
=Sheet1!A5 Vaya con Dios, Chuck, CABGx3 "viv" wrote: I want to be able to use a cell on sheet 1 on another cell in a different sheet but within the same workbook. Example use a5 on sheet 1 in cell c10 on sheet 2. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use cell a5 on sheet 1 in cell c10 on sheet 2
What do you mean by "use"?
=Sheet1!A5 if you put that in C10 then everything that goes into A5 will link to C10 as well Regards, Peo Sjoblom "viv" wrote: I want to be able to use a cell on sheet 1 on another cell in a different sheet but within the same workbook. Example use a5 on sheet 1 in cell c10 on sheet 2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Daily Totals on a summary sheet | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Hybrid Mode
