Reference value in another cell as the value

C

ccgsuper

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.
 
C

ccgsuper

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".
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
I need to cut characters off of a list of text cells... 2
VB Script reference cells for in current table? 1
how to have cells automatically fill when entering value in ref 1
Looking to added up based on a character from cell range 1
copy and paste the cell with formula ="1" 3
How to synchronize all cell values? 1
Copy addition formula of non-consecutive horizontal cells 2

Top