I have Google form feeding into a sheet.
When a row is updated there is a Name column and ID column.
If the ID column does not match the Name column for the specific row based on the table on a separate sheet, I am looking for this to automatically delete the row in the feed sheet (Sheet1). Attached is the idea.
I hope this makes sense! Thanks in advance.