Okay, this is what I've come up with. I adjusted he sheet names, changed the range for "c" to B:B, changed the c.Offset to (0, 3), and used "Cell.EntireRow.Delete".
However, it appears to not just remove duplicates, but remove all entries for certain items. For example, here is my starting data before and after (on Sheet2, Column A). The items that start with 96J are the ones that are not to be altered, which this does fine, but 57C27219 gets eliminated completely, where it should leave one of the entries...
The items in bold are the ones that should be there after, the ones in red are the ones tha should be there, but aren't. Not sure why it gets it right sometimes, but not others...
Before:
96J56467
96J56467
96J56467
57C27219
96J56471
96J56471
96J56471
96J56471
96J56471
96J56471
96J56471
57C27466
57C27205
57C27224
96J56468
96J56468
96J56468
96J56468
96J56468
57C27219
57C27467
96J56469
96J56469
96J56469
96J56469
96J56469
57C27219
57C27468
96J56470
96J56470
96J56470
96J56470
96J56470
57C27219
57C27469
After:
96J56467
96J56467
96J56467
96J56471
96J56471
96J56471
96J56471
96J56471
96J56471
96J56471
57C27205
96J56468
96J56468
96J56468
96J56468
96J56468
57C27467
96J56469
96J56469
96J56469
96J56469
96J56469
57C27468
96J56470
96J56470
96J56470
96J56470
96J56470
57C27469
Bookmarks