I have a list using unique coded ref numbers.
During the data entry process, if the unique code has already been entered,
I use this statement "=1=COUNTIF($A$5:$A$238,A7)" to warn the operator that
it has already been entered and to display the cell ref where it is located.
I would like to create a macro that will locate the record once the warning
is activated.
Any help would be appreciated.