Hi there,
I had a couple queries.
I have sheet that requires to delete some rows. I have 2 headers (which are never in same columns) that I need to find and then delete rows. The Number of rows also varies each day.
Thank you for any help.
I had a couple queries.
I have sheet that requires to delete some rows. I have 2 headers (which are never in same columns) that I need to find and then delete rows. The Number of rows also varies each day.
- Approval Status - Delete all rows with status that does not equal "Pending"
- Created - Delete all rows with dates that today and future dates. Only dates allowed are older then today.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Header 1 | Header 2 | Approval Status | Created | Header 5 | Header 6 | Header 7 | ||
2 | Approved | 3/1/2022 | |||||||
3 | Rejected | 3/16/2022 | |||||||
4 | Pending | 1/1/2022 | |||||||
Sheet1 |
Thank you for any help.