Copying Rows to New Sheet but not moving existing data

Safa Sikder

I have a master sheet that I want to sort into three different sheets. I want to set up an automation that copies a row given the project name, but I also want the automation to make sure that the row it is copying does not exist already in the target sheet. Does anyone know how to reinforce this validation?

Paul Newcome

Insert an auto-number column on the original sheet before copying any rows over. Then insert a checkbox column with a formula to check the box if there is already a row with that same auto-number on it. Finally set up your copy row automation to have a condition to only copy if the box is unchecked.