So I am sorting through a bunch of data manually at the moment and thought I could work on an macro to make some parts of it more efficient by writing a macro.

I have 4 digit numbers usually with the ones digit usually being 1-5 or end in a Z in column B. An example of these numbers would be 0001, 0002, 0003, 0004, 0005 or 000Z. I would like to find all the ones that end in 1 and Z, and delete the whole row associated with it. Essentially any row that contains 1 or Z in its last digit will be deleted. So 0001 and 000Z found in Column B will have it's entire row deleted.

Next, I would like to find digits that are consecutive sequences in the same column B and delete all but the largest number. So if I have a set of data such as 1112, 1113, 1114 in Column B, then I would delete the rows with 1112, 1113.

Is there a way to do this? I really need the help.