Grabbing Dynamic Values and Freezing Them

  • Thread starter Thread starter rbrychckn
  • Start date Start date
R

rbrychckn

So I have a sheet that dynamically tracks numbers over time. Thes
numbers add up cumulatively but I want to be able to freeze that numbe
at intervals over time. So the way I've set this up is:

A
Jun1 04
Jun 8 04
Jun 15 04
etc.

What I'm looking to get is from Sheet1!A73, when Today=A1, take valu
from Sheet1!A73 (just a straight number) freeze it, and put it i
Column B.

Anyone know of a function that can do this? Thanks in advanc
 
Hi
if I understood you correctly this can't be done with formulas as
they'll change/recalculate after you open the workbook again. So do you
want to insert the value of cell sheet1!A73 for each day you open
Excel, or is there more logic involved?
 
Well the original idea was that if the the date in Column A was equal t
today's date, it would just take the value in Sheet1!A73 (say it's 2
at the time). Then a week later, when the next date in Column A i
equal to today's date, it would take the number (which is say 46 then)
but these values would remain what they were at their respectiv
dates.

Sounds, though, like this is impossible
 
Hi
no, not impossible but will require VBA. The only problem is at what
time do you want to fill these values. e.g. should Excel check this if
you open the file and fill column B of your sheet for the respective
row?
 
I see what you're saying. This file is opened every business day, so
imagine that wouldn't be a bad trigger--at a very minimum, the file i
always opened on the days listed in Column A. So if today (as of th
file opening) is equal to the date in A, fill in the corresponding
column. Hope that is clear
 
Back
Top