I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example
Name Number Outcome Colin Smith 12345 Booked Brian Davis 12346 No answer Jimbo Jones 12347 Booked Weyland Smithers 12348 Booked Meg Griffin 12349 No answer
Sheet 2 is a duplicate of all names with the outcome 'No answer',
Name Number Outcome Brian Davis 12346 No answer Meg Griffin 12349 No answer
At the moment I have to regularly filter Sheet 1 to find all the 'No answer' results and copy them manually. Is there a way to set up Sheet2 so any 'No answer' rows are automatically added, then also removed if changed.
I am trying to do this without using macros as this document is duplicated in Google Docs.
How can I accomplish this?