making one cell equal another cell and having the pointer stay fix

[Guest]

I want to make one cell equal another cell. For example I want cell A1 to
equal cell B1. In cell A1 I type '=B1'. Then I enter a value in B1 and I
see the value I typed in A1. But when I moved the value in B1 to another
cell, the formula in A1 automatically changes to point at the cell that I
moved the contents in B1 to. Is there any way I can prevent this?

thanks
Hank

 

[Dave Peterson]

You always want to retrieve the value in B1?

=indirect("b1")

 

[tghcogo]

Hi Hank

I t depends on what you are trying to achieve.

If you no longer need the cells in column A to dynamically change th
simple solution is to highlight column A, "copy" "paste special"
value. "

hope this helps

TGHCOG

 

[Guest]

Yes...this is exactly what I need. Thanks

You always want to retrieve the value in B1?

=indirect("b1")