Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |