you can accomplish this with a userform with comboboxes, you only have to check for double occurances, fill up a combobox with the part numbers and then be able to select the part from a list and delete the entire row.