Formula to capture data on a date and preserve it

J

Jeff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top