VB Code to Find Similar UPC Data

[rizmomin]

Hello:

Please refer to attached file, SHEET1

I have very large data with Sku Number,ItemName and UPC Code.
I need VB Code to do the following

Note:

Similar UPC are like
000123456
00123456
123456



Need to go thru each UPC Code (Column C) to find similar or same UPC Code.
So what I mean is shown in Cell C24,C26,C29.
These are same Product but have Zero in front which creates a totally new product
with new Sku#

Basically what needs to happen is once it finds similar or same UPC then
its corresping SKU number can be added in corresponding cell in column D,E,F, etc
You can see what i have done.

Purpose of the above is to clean up and make Unique product list.

I hope this is clear.


Let me know if you have any questions.
Thanks.

Riz