Hi there,

I need your help in designing a function that would check and see if an existing value in Cell A, starting from Cell A2 downwards already exists, (eg. 2010-000001).

If (2010-000001) already exists, then go ahead and input a new number: 2010-000002 and so fourth.

Basically, I have a userform designed, and when I click on "Add a Record" it would then populate the Cell A3 with the new value (eg. 2010-000002)

Sounds complicated and I really need the help of the Excel VBA Guru's out there.

Much thanks and appreciation for everything in advance,

Cheers,

Jason