Delete cells based on Prefix

I have a macro that currently deletes blank rows in column A and then a few unnecessary columns E and G. The report has changed on me and now in column E I must delete all the locations that begin with "MX " and there is just too many to be selecting one by one. Is there anything I can add to this current macro to delete all Locations that begin with "MX "? there are many other prefixes such as "US" "CA" but the one I need to delete are "MX" the whole row where the MX is found in column E needs to be deleted...

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Its not deleting the MX cells. Actually let me clarify something, the contents of the cells begins with "MX" but has a longer name than that like this "MX Agus buliding 1" or "MX Agus Building 18" or "MX GDL North Campus" and so forth but the prefix is all the same "MX"...

Can you post a sample workbook with some dummy data?

Here is the file... Thanks...

You wouldn't be referring too Column F would you?

Hello John when I copy the macro to the VBA editor, and run it all it does is cycle like if it were opening up excel over and over again and once it completes, it leaves the worksheet without any changes... Any advise?

Where did you place the code? Should be in a Standard Module.

Yes i put it in a Standard Module...