I am tracking the daily values of a project and want to automate the value
storing. I can already download the values and get them split into the
correct sections/worksheets and I have a running date row but when I setup
formulas to transport €śtodays numbers€ť to €śtodays column€ť I cant keep the
formulas active for more than a day because when tomorrow comes the cells
will read an error or FALSE.
Is there a way to say IF AF1 = A1, update AF3:AF17 with A3:A17, and if
AF1<A1, leave current value as is?
where A1 is the downloaded date
AF1 is the today in tracking (AE1 was yesterday, AG1 is tomorrow, and so
on)
A3:A17 are the downloaded daily status values to track
AF3:AF17 are where I need A3:A17 to go today
But tomorrow AG1 I want the AF column to not update from the values it
already has stored.