Automatic Data Changes

I have a work sheet that I use to monitor dates. I need to track up to 5
dates at a time. I would like my worksheet to update automaticaly when I
change the dates.

Let me explain.

The data in A4 through A12 never changes.
The data in B4 through B12 changes weekly.

I need to track the last 5 changes made to B4 through B12.
ex. Lets say B4=10/20/09. I then change B4 to 11/2/09. I want the data from
B4 to go to C15. so C15 will be 10/20/09. Then when I change B4 to 11/16/09,
I want C15 to automatically update to 11/2/09 and C16 to update to 10/20/09.
and so on for 5 dates.

Is this possible or do I have to manually keep doing it?

Thanks

Only way I could see to do it would be through a series of Macros that would
do the updating FIRST, based on the cell you are going to change, and then
ask you to input the new date.

Vaya con Dios,
Chuck, CABGx3





"StevenLWood" wrote:

I have a work sheet that I use to monitor dates. I need to track up to 5
dates at a time. I would like my worksheet to update automaticaly when I
change the dates.

Let me explain.

The data in A4 through A12 never changes.
The data in B4 through B12 changes weekly.

I need to track the last 5 changes made to B4 through B12.
ex. Lets say B4=10/20/09. I then change B4 to 11/2/09. I want the data from
B4 to go to C15. so C15 will be 10/20/09. Then when I change B4 to 11/16/09,
I want C15 to automatically update to 11/2/09 and C16 to update to 10/20/09.
and so on for 5 dates.

Is this possible or do I have to manually keep doing it?

Thanks