Finding and Deleting Duplicates and Entire Rows

[jamesdean1379]

Okay, I am working on putting together a workbook I can use to track data progression. Every day I will be pasting data from one report into this workbook that I am working on. I am looking for a couple of things.

1st is finding duplicates between two worksheets and deleting entire row on one worksheet if no duplicates are found
Looking for a macro that will find duplicates between Column G on worksheet Inventory and Column F on worksheet Data. If column G(worksheet Inventory) does not contain any duplicates from Column F(worksheet Data) then delete entire row on worksheet Inventory.

2nd is searching for duplicates on 1 worksheet and checking cell in column for value and deleting entire row if value in column is blank
So this one will search for duplicates in column G and then check the corresponding cell in column K for values. If duplicate is found and one of the duplicates has a blank for the corresponding cell in column K then delete the entire row for that one.

Example below, so in this case the bottom row would need to be deleted. Rows for the workbook go up to 5,000

G	H	I	J	K
ID	Order #	Order Date	Customer	Comment
CDA852	A8	03/02/22	CUSTOMERA	SHIPPING 03/17/22
CDA852	A8	03/02/22	CUSTOMERA

 

[Shortmeister1]

I think you're looking at this the wrong way.


The aim should be to stop people entering duplicate IDs. Always a bad practice to try and retrospectively fix something.

You don't need VBA to achieve this as it can be done using validate functionality.

Check out the following link:

Excel formula: Data validation unique values only