Hi All
I hope you can help on this please
In column "A" ! have a date (16/3/18)
In column "E" I have a name
What I want please is some VBA that will delete any duplicate Names that match the same date
16/3/18 John
16/3/18 John Delete
16/318 Jill
21/3/18 Jack
21/3/18 Jack Delete
Any help will be most welcome
EDIT: Sorry forget to mention. its the whole row that i need deleting
I hope you can help on this please
In column "A" ! have a date (16/3/18)
In column "E" I have a name
What I want please is some VBA that will delete any duplicate Names that match the same date
16/3/18 John
16/3/18 John Delete
16/318 Jill
21/3/18 Jack
21/3/18 Jack Delete
Any help will be most welcome
EDIT: Sorry forget to mention. its the whole row that i need deleting
Last edited by a moderator: