I have various data in a column, and I want to include deleting them in a formula macro.
For example, I want the macro to run so that whenever it sees ANY ROW which contains the Text XX, YY, or ZZ etc it erases it.
So the macro would basically look for any of those three values and delete the entire row they are in. It would keep deleting ALL the rows until there are no more occurrences of the text.
For example, I want the macro to run so that whenever it sees ANY ROW which contains the Text XX, YY, or ZZ etc it erases it.
So the macro would basically look for any of those three values and delete the entire row they are in. It would keep deleting ALL the rows until there are no more occurrences of the text.