Microsoft Excel Formula problem?

[Kelvin]

I want to write a simple formula in microsoft excel which references a particular cell in a different worksheet. However, if the location of the referenced cell moves, due to the insertion of a row or column for example, I don't want the formula to 'follow' the cell so the value stays the same, but continue to reference the original cell position. I've tried making the referenced cell an 'absolute reference' using dollar signs but this only applies if the cell containing the formula moves, not the reference. Any Ideas??

[kempie]

Try this formula

=INDIRECT(ADDRESS(1,1,1,TRUE, "Sheetname"))

where 1st no. is the row no. of referenced cell

and 2nd no. is column no.  e.g. A=1  B=2  C=3  etc.

[kempie]

Silly me you can just use INDIRECT with your cell reference in quotes

=INDIRECT("Sheetname!B3")

[Kelvin]

Kempie you are a genius, technological as well as financial!!!