yogi_Record Value Of A Changing Entity By Date using A Formula Based Approach

Google Spreadsheet   Post  #2437

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-29-2018

question by: Maxime Biver
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/HgYJsGPqCcM;context-place=mydiscussions

Spreadsheet, auto filing process according to the date
Hey guys, 

I'm struggling a bit with gSheet :

I have a value in cell, lets say A1 that is changing often, its the value of my port folio.

I would like to do another spreadsheets that is picking up the value in that celle (A1) every day for example and fill the cell B1 on the 1st of may, then B2 on the 2nd of may etc etc

How can I do that ? I was trying with IF and NOW but it looks like they don't go together and I'm not able to auto copy and paste the value in cell A1.

Thank you for you help !