1

Suppose I have a row A2:D2 as in the image:

screen shot

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:

screen shot

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.

Improve this question
5
  • 1
    Can you share a sheet? The way your asking the question, its unclear what you expect the end result to be
    – Aurielle Perlmann
    Jan 3 '17 at 12:29
  • The last result should be like this docs.google.com/spreadsheets/d/… note: the F2 is imported form another sheet
    – AAlkhabbaz
    Jan 3 '17 at 12:59
  • Are you copying and pasting the other data as well - or are columns A,B,and D also automatically inserted into the sheet?
    – Aurielle Perlmann
    Jan 3 '17 at 13:16
  • No, I shouldn't copy anything, only B column is editable, users should drag the row to generate new row with the current gold price every day
    – AAlkhabbaz
    Jan 3 '17 at 14:46
  • the price (D Column) should be fix and persistent forever
    – AAlkhabbaz
    Jan 3 '17 at 14:50
1

If I understand your questions correctly, you want to be able to change the value in F2 but keep a history of that value in the 'C` column. All this, while all other cells update automatically by dragging down the cells.
In that case, I don't know a possible way.

What you could do is to not get the C column value from the "Current Gold Price" value in the F2 cell, but perhaps have it pulled directly from the source. It depends on how your source is. If that is a column that gets updated based on the date then use it as a reference just as you are doing with F2.

Improve this answer
3
  • 1
    Thank you, that exactly what I want, but unfortunately, the source updates the cell every while, not adding new cell :(
    – AAlkhabbaz
    Jan 3 '17 at 19:29
  • Is the source only one cell that gets updated manually? Not a column?
    – slybloty
    Jan 3 '17 at 19:30
  • Yes only one cell
    – AAlkhabbaz
    Jan 3 '17 at 20:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.