No macro required.
Just sort the list by the column containing the status. Then delete each block of rows containing the status you don’t want.
No macro required.
Just sort the list by the column containing the status. Then delete each block of rows containing the status you don’t want.