Is there any way to have a formula within a cell automactially change to a
value by itself? To put this into context, here's a small example. In cells
A1:A12 I have the title of the months plus "forecast" (Jan Forecast, Feb
Forecast, March Forecast,...Dec Forecast). In cells B2:B13 I have the exact
same lookup formula referencing the same cell, G1 (value of 10). I use the IF
formula to not show anything in cells B2:B12 (for now), so let's just
concentrate on cell B1. So my result in B1 = 10. Cell G1 will change
automatically in another month to another value of say 23, so now I want cell
B2 (Feb) to show the 23, but cell B1 to still show 10. In order to do this
cell B1 has to convert to a value instead of a formula. Is there something I
can do rather than manually copying and past valueing the cell?