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.
Bookmarks