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 seems tough--any suggestions?
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 seems tough--any suggestions?