I need to be able to delete rows in Excel based on whether or not the first two characters in the table are in the cell in the spreadsheet.
i.e. I have a tab called 'Table'
in Colum 'A' I have
[This can be added to so I need to look at the whole of column A]
I need my Macro to look up 'Table' and if in Sheet1 Column J any of the data starts with any of those listed in the Table, column 'A' I need to delete the row.
So, if in Sheet1 in Column J 4 I have CZB123456789 I need to delete that row
if in Sheet1 in Column J 150 I have POV123556779 I need to delete that row