VB Code to compare 2 columns of data

Hello:

Please refer to attached file.
I have date in Column A and check # in Column B.
I need VB Code to go thru the data and do the following:
Compare the check# with the date.
I need a unique check number for a given date.
Looking at the attached file, i have highlighted yellow.
Here i have Check # 2947 for 6/1/2016.
Now i see Check # 2947 for 6/15/2016.
SO in this case i need to add 1 at the end of check # for 6/15/2016.
So the yellow highlighted field would become "29471"
I have other data down the list the same issue.
I hope this is clear what i am trying to accomplish

Let me know if you have any questions.
Thanks.

Riz

Hello JB and Crooza:

If check # occurs more then 2 dates then add "2", "3" and so on at the end of the check.
Please let me know if you have any questions.
Thanks.

Riz

Try this

Please Login or Register  to view this content.