| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed Formula
When i create a formula from another sheet i can not fixed the link. Examply
the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the column of the A column then the formula gets the new data as "=Sheet2!$B$1" but i don't want to excel point the new cell, i want it to be fixed at "=Sheet2!$A$". Any way to solve this problem? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed Formula
=INDIRECT("sheet2!A1")
-- Kind regards, Niek Otten Microsoft MVP - Excel "Tsunamic" wrote in message ... | When i create a formula from another sheet i can not fixed the link. Examply | the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the | column of the A column then the formula gets the new data as "=Sheet2!$B$1" | but i don't want to excel point the new cell, i want it to be fixed at | "=Sheet2!$A$". Any way to solve this problem? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed Formula
=INDIRECT("sheet2!$A$1")
-- David Biddulph "Tsunamic" wrote in message ... When i create a formula from another sheet i can not fixed the link. Examply the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the column of the A column then the formula gets the new data as "=Sheet2!$B$1" but i don't want to excel point the new cell, i want it to be fixed at "=Sheet2!$A$". Any way to solve this problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with fixed details | Excel Worksheet Functions | |||
| Keep formula fixed | Excel Discussion (Misc queries) | |||
| HOW CAN I FIXED FORMULA THAT DISPLAYS #NA | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| FIXED formula problem | Excel Worksheet Functions | |||
Hybrid Mode
