I am attempting to build a macro that looks at a certain cell. If that cell is equal to 0.00%, then it will delete the entire row. I would need it to repeat the same function until it finds no more data in the selected cell. In addition, I have multiple tabs within the excel spreadsheet that are set up the same exact way. Is there a way for the macro to repeat the same task on any tab within the file?
I am attaching a spreadsheet as a reference.
Column BI is where the macro would need to look for specific percentages. If the percentage equals 0.00%, then delete. If it is any higher than that, then keep the row and continue down the list. Repeat same function on tab 2 or any additional tabs.
I am asking this question from a beginner standpoint, so I appreciate any type of advice.