I have a table labeled "Disputes" that has its headers in cells F29-R29. Column R29 of the table is a helper column I added in with an equation that lets me know which rows of the column can be deleted
Formula in column R:
=IF(OR([@[Date Resolved]]>DATE(YEAR(TODAY())-2,MONTH(TODAY()),1),[@Status]="Open Disputes"),"Don't Delete","Delete")
Can someone help me either:
1. Write a macro that will delete rows in the table "Disputes" based on that formula above where I don't need the helper column and can remove it (ideal solution)
or
2. Write a macro that will delete rows in the table "Disputes" using the helper column I added in column R? Basically delete every row of the table that has the word "Delete" written in column R
I only need the row of the table deleted, not the spreadsheet row, because there is a different table to the left of this one that needs to remain intact.
Thanks!
Formula in column R:
=IF(OR([@[Date Resolved]]>DATE(YEAR(TODAY())-2,MONTH(TODAY()),1),[@Status]="Open Disputes"),"Don't Delete","Delete")
Can someone help me either:
1. Write a macro that will delete rows in the table "Disputes" based on that formula above where I don't need the helper column and can remove it (ideal solution)
or
2. Write a macro that will delete rows in the table "Disputes" using the helper column I added in column R? Basically delete every row of the table that has the word "Delete" written in column R
I only need the row of the table deleted, not the spreadsheet row, because there is a different table to the left of this one that needs to remain intact.
Thanks!