Within a Google Sheet I have multiple sheets representing the different stages in a recruitment process.
Each stage is also represented as an individual sheet and is selectable via an 'in-cell' dropdown menu to select the status of a particular applicant.
I need a google script to copy the entire values of a row in one sheet,
Once triggered this row needs to move 'values only' to the next empty row in the specified sheet.
e.g *John Smith* *Status - Stage 2* - Move row values to the 'Stage 2 Sheet in the next unpopulated row.
Happy too provide a demonstration to help visualise the process.