Suppose I have a row A2:D2
as in the image:
Column C
represents Gold Price of this day. Coulmn A
represents the date.
Cell F2
represents the Current Gold Price.
C
cells formula: =F$2
.
When I drag the row down I get A3:Z3
:
If the price changes at F2
then the C
column will change showing the new value of F2
.
I want to automatically copy the current value of F2
and insert it in the dragged cells CN.