software

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!

=INDIRECT(quot;B2quot;)

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

quot;PKquot; gt; wrote in message
...
gt;I am sure the answer to this one is rather simple, but for some reason it
gt; eludes me.
gt;
gt; I need to reference a particular cell regardless of whether or not the
gt; cell
gt; is moved.
gt;
gt; For example:
gt; In cell A1 if I enter formula
gt; =$B$2
gt; it makes A1 equal to cell B2. HERE IS THE PROBLEM: If I cut cell B2 and
gt; paste it in cell B5, the formula in A1 changes to =$B$5 I need it to
gt; stay
gt; as =$B$2
gt;
gt; My actual problem involves a complicated financial spreadsheet that I want
gt; the user to be able to re-arrange using cut and paste. I simplified the
gt; question by posting the problem in this form.
gt;
gt; Thanks in advance for any help!
BINGO!

Thanks Bernard!!!!!!!!!

quot;Bernard Liengmequot; wrote:

gt; =INDIRECT(quot;B2quot;)
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;PKquot; gt; wrote in message
gt; ...
gt; gt;I am sure the answer to this one is rather simple, but for some reason it
gt; gt; eludes me.
gt; gt;
gt; gt; I need to reference a particular cell regardless of whether or not the
gt; gt; cell
gt; gt; is moved.
gt; gt;
gt; gt; For example:
gt; gt; In cell A1 if I enter formula
gt; gt; =$B$2
gt; gt; it makes A1 equal to cell B2. HERE IS THE PROBLEM: If I cut cell B2 and
gt; gt; paste it in cell B5, the formula in A1 changes to =$B$5 I need it to
gt; gt; stay
gt; gt; as =$B$2
gt; gt;
gt; gt; My actual problem involves a complicated financial spreadsheet that I want
gt; gt; the user to be able to re-arrange using cut and paste. I simplified the
gt; gt; question by posting the problem in this form.
gt; gt;
gt; gt; Thanks in advance for any help!
gt;
gt;
gt;