We have a field that contains $ amount. This field is being updated in a
daily basis using a pivot table.

Currentlly this field loks like this:

As of 8/17/06 = $100 and this figure is being updated in a daily basis so
the following date, it will look like this: As of 8/18/06 - $120.

However, we want to track that field in a daily basis.

Meaning:

8/17/06 = $100
8/18/06 = $120
8/19/06 = ...

We would want to programmatically copy and paste this as values to a
calendar of days so we can track it in a daily basis.

Is there a way to do this?

Thank you.