Delete row if cell in Column N equal "Different" or Column P equals "Blank"

Ok, I've taken what I've learned through there with some help from another source, and I've come up with this. As it stands it runs perfectly, except it doesn't do everything I need it to do.

As it stands it looks in N and removes everything that doesn't equal "Different". I need it to also delete the row if P equals "Blank".

Attached is the workbook and the code below.


Here is the original code.

Please Login or Register  to view this content.

I thought originally if I had this in there it would work, but it seems to ignore the second part of it, so I need help on making it so that these work together to do as described in the title. If someone could help it be appreciated.

Please Login or Register  to view this content.

Think I solved it, but I may need help with something else, give me a min.

OK solved my issue, I realized I was pushing the data before doing the filtering, so I adjusted it so it would. Now a new one comes up. For some reason when it exports to the PO Tracking tab the last two rows are left unformated... I don't know why at least yet. If someone can take a peek at the code below and show me where I need to adjust it be greatly appreciated.

Here is what I came up with...

Please Login or Register  to view this content.