Delete rows with duplicate information
I have a sheet on which I import data from an external source. After
importing data, I need something to remove complete rows that match a
specific criteria.
For example:
I have in Column D a Date and in column E an EmployeeName and in
column F and OrderNumber.
after my import, I need some vba that runs through my data quickly to
remove all existing rows that have the same Date, the same
EmployeeName and an empty OrderNumber.
For example
D E F
row 50) 17-08-2007 Mark 12345
row 60) 17-08-2007 Mark
row 62) 17-08-2007 John
In this case, only row 60 should be removed
Thank you very much
|