I have no idea how to write a macro that would do this but this is what I need.
If in column b the word "count" appears in a cell with other text and if next to it in column c equals "1". I want that row and the row above it to be deleted.
Cause I don't know how to write this, I am currently doing this manually.
Please help, I'm growing very impatient. Thanks
If in column b the word "count" appears in a cell with other text and if next to it in column c equals "1". I want that row and the row above it to be deleted.
Cause I don't know how to write this, I am currently doing this manually.
Please help, I'm growing very impatient. Thanks