hi all,

hello my name is Jeff, i work as a quantity surveyor in auckland, new
zealand. i need a function creates a Quote Number everytime i click
at a command button. as sometimes we double the quote number. and if
there are anyway to check if there are some Quote Number that was
double. example is if dn5555 has appeared twice in column A.

Example below

Cell Value
A1 dn0001
A2 dn0002
A3 dn0003
..
..
..
A9999 dn9999

thanks in advance. appreciate any help.

cheers.

Jeff