Excel too helpful! (problem with absolute reference)
 

I am sure the answer to this one is rather simple, but for some reason it
eludes me.

I need to reference a particular cell regardless of whether or not the cell
is moved.

For example:
In cell A1 if I enter formula
=$B$2
it makes A1 equal to cell B2. HERE IS THE PROBLEM: If I cut cell B2 and
paste it in cell B5, the formula in A1 changes to =$B$5 I need it to stay
as =$B$2

My actual problem involves a complicated financial spreadsheet that I want
the user to be able to re-arrange using cut and paste. I simplified the
question by posting the problem in this form.

Thanks in advance for any help!

Excel too helpful! (problem with absolute reference)
 

=INDIRECT("B2")

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PK" wrote in message
...
I am sure the answer to this one is rather simple, but for some reason it
eludes me.

I need to reference a particular cell regardless of whether or not the
cell
is moved.

For example:
In cell A1 if I enter formula
=$B$2
it makes A1 equal to cell B2. HERE IS THE PROBLEM: If I cut cell B2 and
paste it in cell B5, the formula in A1 changes to =$B$5 I need it to
stay
as =$B$2

My actual problem involves a complicated financial spreadsheet that I want
the user to be able to re-arrange using cut and paste. I simplified the
question by posting the problem in this form.

Thanks in advance for any help!

Excel too helpful! (problem with absolute reference)
 

BINGO!

Thanks Bernard!!!!!!!!!




"Bernard Liengme" wrote:

=INDIRECT("B2")

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PK" wrote in message
...
I am sure the answer to this one is rather simple, but for some reason it
eludes me.

I need to reference a particular cell regardless of whether or not the
cell
is moved.

For example:
In cell A1 if I enter formula
=$B$2
it makes A1 equal to cell B2. HERE IS THE PROBLEM: If I cut cell B2 and
paste it in cell B5, the formula in A1 changes to =$B$5 I need it to
stay
as =$B$2

My actual problem involves a complicated financial spreadsheet that I want
the user to be able to re-arrange using cut and paste. I simplified the
question by posting the problem in this form.

Thanks in advance for any help!