Formula to capture data on a date and preserve it
 

I have set up a spreadsheet to run a macro and pull data from a DB. This
works well but is limited in the fact that is is a snap shot in time and I
would like to be able to build an historical perspective of the data.

is there a way to use the today() function or some other function in a
series of cells to only update the cell once and then maintain that data
moving forward? I only want to update the data on the day in question



--
Jeff