Copy Row Automation
I have a workflow which when a new row is added and fulfils a set criteria, the row is copied across to one of two sheets. When it copies across, the row is filled in in its equivalent row in the primary sheet. How can I get the copied rows to fill in the next available row on the new sheet?
Here is an example of the row being copied to a its equivalent row 26 on the sheet it is being transferred across to