Copy WHOLE Row if citeria matches

Hi Everyone

Really basic user here but please can someone help me with the attached spreadsheet. I need to be able to copy the information of the WHOLE row automatically if the criteria in 'N' shows 'SOLD'. I dont want to have to run a Macros (pressing Alt + F8 everytime) if I can help it. Or if a macros is running will this automatically update when new information is updated?

The spreadsheet will be continually updated therefore I need the Macros to be set to an extremely large row range, or if someone can advise which part of the Macros needs to be updated for this.

Thanks

Hayley