if a cell has a special value, the whole row should get to a special spreadsheet

In which columns is the "Sold" found? Please attach a sample.

Thanks for the fast reply.

I´ve created an example.

greetz benjamin

This is auto code. When you make change in column F to yes, that row will be copied.
I am not sure if the columns on both sheet match.

Great thank you.

This works perfectly well.

Just one question more, in case that the user is puttíng the vehicle on "yes", but this was wrong. Is it possible that when he puts no again that it jumps back to the spreadsheet overview vehicle?

greetz benjamin

No, once yes is changed or entered, it is deleted from the sheet and pasted in to sold sheet.
I know there is a undo option but I have never tried it.
I have put another code on sold sheet, so if yes is changed, it puts back in to sheet overview. If you change you mind, run the code from sheet sale and put back the mistaken row.

Thanks a lot

greetz