VBA code to delete duplicate rows based on multiple conditions

Hello,

I would like to create a VBA code that will delete rows if they are the same as a previous row. However, not all of the data may be the same throughout all of the rows so I need to be specific about the columns that will be used to see if the rows are the same. The columns that I would like to see if there is a match is the code, date, data 1, and data 2. If all of these criteria are the same for any of the other rows on the sheet, I would like them deleted. I have attached a small sample. In the sample the code should result in either row 2 or row 3 being deleted. Thank you for your help.

f all of these criteria are the same for any of the other rows throughout the workbook I would like them deleted.

Do you mean the macro should check if all the sheets are populated with data and then run the macro?

I understand that you have given these 4 columns for the sample file. Does your original file also have these 4 columns or are there many more?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.