Quote Originally Posted by analyst View Post
@p45Cal

Thanks Brother, the above code works, except what is sought at Serial No. 5,6,7 in post #1, however is not done properly. I mean where there is no pair of row having data in Column E "YY", followed (subsequent row) having "ZZ" is not deleted.
I said as much in my last post. Since you have redacted data from the sheet your sample file does not appear in pairs below the last XX. I was hoping you'd post another file with more realistic data, still redacted but more 'true-to-life'. You can do this with search and replace used with a bit more finesse so that at least column B isn't all the same. Ideally, all the sort columns would contain sortable data. I know it's a bit of work for you but it means less work for me and I won't be guessing wrongly about the kind of data you have in your sheet. Help me to help you.