Copy rows to new sheet automation or better way to do this?

Hi,

I have one sheet which has a form connected to it. Once someone submits the form, I have a drop down which I switch to "confirmed" when I have uploaded the submitters info.

Once I select, "Confirm" I want two specific cells in the row to copy to a different sheet. What would be the best way to do this? I have tried the copy row function, but cant seem to find a way to copy specific cells from the row to another sheet.


Thanks!

Answers