recording range changes

[shelbytherobot2]

if i have a range on a sheet that is frequently changed... but i want to record the OLD values in the range... i would do what?

track changes?

is this possible?

i am looking to show whether the values went UP or DOWN from the previous value.

can this be done automatically?

please help

[Mordred]

Have you considered putting your data into a chart?

[MarvinP]

Hi,

I think I'd copy the old range to another spot on the worksheet before the current range is changed. Then you can compare the new with the old. I you will need to save the old values somewhere to compare them to the new.