Hi,
I need code to delete all rows relating to the ID number in column D if D51, D53, D54 or D54 is evident in column B.

See example below;
20/01/2014 D51 toysc 5097 XXX --/--/-- 20/01/2014
13/01/2014 D60 toysc 5097 D52 17/01/2014 20/01/2014 - both lines deleted as D51 evident in B1

22/01/2014 D52 toysc 6464 XXX --/--/-- 22/01/2014
23/04/2014 D52 toysc 6464 XXX --/--/-- 23/04/2014
09/01/2014 D52 toysc 6464 D52 10/01/2014 13/01/2014
15/01/2014 D52 toysc 6464 D52 22/01/2014 22/01/2014
07/01/2014 D60 toysc 6464 D52 13/01/2014 09/01/2014
13/01/2014 D60 toysc 6464 D52 15/01/2014 15/01/2014
15/04/2014 D53 toysc 6464 D52 23/04/2014 --/--/-- - All lines deleted as D53 evident in B9

20/01/2014 D58 toysc 6482 XXX --/--/-- 20/01/2014
07/02/2014 D51 toysc 6884 XXX --/--/-- 07/02/2014
03/02/2014 D54 toysc 6884 D52 07/02/2014 07/02/2014 - All lines deleted as D54 evident in B12

Thanks in advance