Hi enclosed is sheets , what i am trying to do is below.....
(Not sure if this is possible)
MATCH COL D OF THIS SHEET, WITH COL G OF SHEET 2,.
IF SAME ROW HAS BLANK IN COL I AND A "REL" IN COL J IN SHEET 2, HIGHLIGHT ON HERE
BY COLOUR AND BOLD TEXT, AND GIVE USER OPORTUNITY TO DELETE ALL BUT THE MATCHED ROWS ON THIS SHEET…
ALSO IS THERE A WAY OF IF THE SHEET NAMES WERE SETUP LIKE THIS ("M50" AND "M55" AND "M74")
TO MAKE THE CODE RUN ON EACH SHEET APART FROM "KTAB" SHEET
Many Thanks
Merc