Automatically Deleting Rows Based on Conditions in Excel

·

Hey, is there a way to automatically delete a row after a condition is met?

· Sorted by Oldest

Clay Team
APP
·
·
Hey there Bruce thanks for reaching out
Bruce W.
·
·
I have one table that will get to way over 50k rows, but once the enrichment is done I am sending it to a different location
Bruce W.
·
·
So I need to be able to automatically delete that row with code once a formula is met
Clay Team
APP
·
·
Automatically deleting rows isn't possible, but a workaround would be to create a view for all rows that do not meet the condition and then selecting all and deleting all at once.
Clay Team
APP
·
·
You can do so by creating a filter and than making a view for that filter.

Clay Team
APP
·
·
Hey there Bruce thanks for reaching out
Bruce W.
·
·
I have one table that will get to way over 50k rows, but once the enrichment is done I am sending it to a different location
Bruce W.
·
·
So I need to be able to automatically delete that row with code once a formula is met
Clay Team
APP
·
·
Automatically deleting rows isn't possible, but a workaround would be to create a view for all rows that do not meet the condition and then selecting all and deleting all at once.
Clay Team
APP
·
·
You can do so by creating a filter and than making a view for that filter.