Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a fixed cell
from one sheet I am linking a cell to another sheet.
e.g. SheetAA cell A1 = SheetBB cell A7 Now I insert a colomn in sheetBB and the content of cell A7 moves to B7, the content in SheetAA cell A1 automatically links now to SheetBB cell B7, however I would like it to stay linked to SheetBB cell A7, is this possible? Thanks Mas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a fixed cell
Try this:
=INDIRECT("SheetBB!A7") -- Biff Microsoft Excel MVP "Mas" wrote in message ... from one sheet I am linking a cell to another sheet. e.g. SheetAA cell A1 = SheetBB cell A7 Now I insert a colomn in sheetBB and the content of cell A7 moves to B7, the content in SheetAA cell A1 automatically links now to SheetBB cell B7, however I would like it to stay linked to SheetBB cell A7, is this possible? Thanks Mas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TOC with link to fixed cell, NOT tab | Excel Discussion (Misc queries) | |||
How can I assign a data for one cell from another fixed cell? | New Users to Excel | |||
how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Fixed cell references | Excel Discussion (Misc queries) |