Record and retain the date when cell value was FIRST changed!

[Phil Payne]

Hello all

I need your expert assistance again please.

I have status columns with validated codes (ascending from 1 to 11) on Sheet1 that when selected by the user inputs the date of change of status into an adjacent cell. Over time the status changes from 1 through to 11 and on each change of status the date in the adjacent cell changes accordingly.

All that is OK but now I need to record when a particular status is reached that, when subsequently changed, will not change the status date. (I need to retain for the record when each status 9 was achieved.)

Is there a way to record and retain the date when status value was FIRST changed to Status 9?

I presently display all the status dates found on Sheet1 (up to 6026) on Sheet2. I am hoping to modify the Sheet2 formula or employ VBA to get what I need.

I hope someone can provide a solution.

Thanks very much!

 

[jim may]

Thanks Jim.

I am as sorry as I can be, but when I look at your existing "change" code, I am overwhelmed and suddenly feel I'm "in over my head".
I do not know how, or where to start.

I am unable to help you.

Good luck...

Jim

 

[Phil Payne]

Not a problem Jim,

You've given me a great deal of your time and assistance I appreciate it very much.

Thanks and all the best.

Phil

I am as sorry as I can be, but when I look at your existing "change" code, I am overwhelmed and suddenly feel I'm "in over my head".
I do not know how, or where to start.

I am unable to help you.

Good luck...

Jim