Fixed Formula

T

Tsunamic

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?
 
N

Niek Otten

=INDIRECT("sheet2!A1")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?
 
Top