Copy New Row, Delete Old Row
I have a quick question. I have a process by which a row gets copied (from Sheet A) into another sheet (Sheet B). Since there will be duplicate rows in Sheet A, I'm wondering if there is a way in which when the row gets copied into Sheet B, a row can be deleted if another already exists?
Essentially, I'm looking to avoid having duplicate rows so I can always see the most up to date one (because it'll have the most up to date attachments/comments).
Help Article Resources
Check out the Formula Handbook template!