All,

I have a program which puts in a status in column U based on a value range.
Unfortunately the range gets incremented with each roll and sometimes causes the status to change from a good "true" status to another statues value which makes it "not true". I need a code which will take the first value which is always the correct one and copy over the existing values for
each value in column A that's the same.

Here's an sameple result of what needs fixed.

Row1
columnA and column U
1 10000 Good
2 10000 Need Soon
3 20000 Need Soon
4 20000 Warning very Low
5 33300 Good
6 33300 Need Soon
7 44444 Get Now
8 44444 Get Now
9 44444 Get Now
10 44444 Unacceptale level
11 65656 Need Soon
12 65656 Need Soon
13 65656 Unacceptable level
14 65656 Unacceptable level
15 88080 Good
16 88080 Need Soon
...to Last row

and the fixed result should be:

1 10000 Good
2 10000 Good
3 20000 Need Soon
4 20000 Need Soon
5 33300 Good
6 33300 Good
7 44444 Get Now
8 44444 Get Now
9 44444 Get Now
10 44444 Get Now
11 65656 Need Soon
12 65656 Need Soon
13 65656 Need Soon
14 65656 Need Soon
15 88080 Good
16 88080 Good


I'm going crazy trying to figure how to make this work.
Any help is appreciated.

thanks,

BDB