Hello,
I’m looking to delete rows in a spreadsheet dump based on multiple criteria using VBA. I’ve attached a spreadsheet that shows the raw data and another tab that shows the desired results.
Here’s what I’m trying to accomplish:
If column AH has a value of “OFF”, then I need to delete not only that row, but any other row that has the same SYS # in column AF as that record.
So, in the attached, rows 6, 14, 15, and 22 would all need to be deleted.
Hope this is clear enough.
Let me know if you have any questions and thanks in advance for any help provided.
Regards,
JL