I have a long list of data consisting many columns but
Column And B are Important Column A consist of Unique
reference numbers and column B shows their status.
Statuses are CURRENT, MOVED or CLOSED. The status MOVED
can appear many times for the same URN while CURRENT or
CLOSED would appear once.

An userform is used to amend the list. I want to add a
code so when the OK button is clicked the code will check
that the URN exists and if it does then it has a status
CURRENT. If these to conditions are not met then exit sub.

Your help with the code would be appreciated. Thanks in
advance.

Regards