I have a sheet in a document with details of hundreds of signups for an event. As part of this event, there are roughly sixty 'centres'. People have signed up through one form, and now I want to allocate them to centres.
I've created a new column in the big "Master Sheet" (where the form submissions are dumped) called "Allocated Centres", and a new sheet in the document for each centre - let's use "Centre A" as an example.
I would like to copy the whole row of information from "Master Sheet", where the value in the column "Allocated Centre" is "Centre A", to the new sheet created for that centre.