| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sht 1 cell a to track contents sh 2 cell n
I would like for a cell in sheet 1 of a workbook to track the contents of a
single cell on sheet 2 of the same workbook. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sht 1 cell a to track contents sh 2 cell n
Try this formula on sheet 1 or any other sheet to mirror what is in a1 of
Sheet 2 =Sheet2!A1 Mike "nick" wrote: I would like for a cell in sheet 1 of a workbook to track the contents of a single cell on sheet 2 of the same workbook. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sht 1 cell a to track contents sh 2 cell n
What do you mean by "track the contents"?
You can enter =Sheet2!cellref into a cell on Sheet1 and as you change the source cell contents, the destination cell will change to match. Gord Dibben MS Excel MVP On Tue, 5 Aug 2008 10:57:00 -0700, nick wrote: I would like for a cell in sheet 1 of a workbook to track the contents of a single cell on sheet 2 of the same workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| Returning Cell Contents of One Cell Based On Another Cell | Excel Worksheet Functions | |||
| Excel 97 SR-1 / Set date in a cell-have day track in another cell | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Hybrid Mode
