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
Bookmarks