Reference value in another cell as the value
 

Is there a way to see the "value" of a formula in cell B1 in cell B2 without
copying and using paste special, "Value"? I would like it to be automatic if
the value in B1 changes.

Reference value in another cell as the value
 

Him

In B2 enter the formula

=B1

mike

"ccgsuper" wrote:

Is there a way to see the "value" of a formula in cell B1 in cell B2 without
copying and using paste special, "Value"? I would like it to be automatic if
the value in B1 changes.

Reference value in another cell as the value
 

That is true, but it does not show the value of B1 as it would if you copy B1
and
paste special....value only into B2. When looking at B2 you see "=B1".
"Mike H" wrote:

Him

In B2 enter the formula

=B1

mike

"ccgsuper" wrote:

Is there a way to see the "value" of a formula in cell B1 in cell B2 without
copying and using paste special, "Value"? I would like it to be automatic if
the value in B1 changes.

Reference value in another cell as the value
 

Unless I'm missing something, in cell b2

=b1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ccgsuper" wrote in message
...
Is there a way to see the "value" of a formula in cell B1 in cell B2
without
copying and using paste special, "Value"? I would like it to be automatic
if
the value in B1 changes.

Reference value in another cell as the value
 

Hi,

You see that if you look in the formula bar but not in the cell, there you
see the value that B1 formula evaluates too.

If you want the value to appear without a formula then you must resort to
VB. Tight click your sheet tab, view code and paste this in

Private Sub Worksheet_Calculate()
Range("B2").Value = Range("B1").Value
End Sub

Mike

"ccgsuper" wrote:

That is true, but it does not show the value of B1 as it would if you copy B1
and
paste special....value only into B2. When looking at B2 you see "=B1".
"Mike H" wrote:

Him

In B2 enter the formula

=B1

mike

"ccgsuper" wrote:

Is there a way to see the "value" of a formula in cell B1 in cell B2 without
copying and using paste special, "Value"? I would like it to be automatic if
the value in B1 changes.