Copy cells values at a particular time and date

[Geraint]

Hello,

I would like to be able to copy cells for their values at
a particular date and time. i.e A1 has the value of 4 on
16/08/03 but is 5 on the 17/08/03, I would like to copy
these values onto two cells automatically.

please help or I will have a huge amount of admin work to
do.

Thanks in advance

 

[Otto Moehrbach]

Geraint
Do you want to copy that cell every time it changes or just at some
specific time and date? What date? What time? HTH Otto

 

[geraint]

Hi,
Thanks for the reply. the cells will change many times, I
just want to capture their value on a weekly basis at a
certain time and date.

 

[Geraint]

Hi,

well, no help so far. I wanted it to change on every
Monday at 07:00 am. Not sure if this information helps.
Thanks in advance.

Geraint