I would appreciate any help in writing a macro to go to all active sheets and find the column named "Market." Once that column is found I would like to delete all rows containing 0. I would then like to go to column 1 of all active sheets and delete all rows containing "national assignment." I tried recording the macro within excel but it does not work correctly when recorded because of absolute references that change with each data update. Thank you.