I am trying to clean up Rows Based on what I put in as a MFG name and have it search in the A column and delete entire Row. I attached a sample to assist!

Thanks!