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