Deleting rows if a cell value = "x"
Posted by Steve Bridge on October 02, 2001 6:13 PM
I am trying to write a macro (simple, really) that will take my worksheet (with the headers: PartNumber, Manufacturer, Quantity, Price, DateCode...) and find all values in the Manufacturer column, and if = to "MO" or "IT" then DELETE that row. OR, if that value = "AM" then multiply value in "Price" column by 1.05.
I need to do this with a macro. I will create a button in Personal.xls and run it from there.
Thank you much for your help.