Hi guys,

I am a total XLS noob...I use tutorials to learn the most basic functions. Which is why I've come here for help on a very complex issue I have:

I have a spreadsheet that has survey results for about 250 athletes. The spreadsheet has the names,birthdates,etc + answer to about 12 survey questions + other erroneous data. The 12 survey questions are all answered with "yes" "no" or "unknown". In the spreadsheet itself yes= 1, no= 0, unknown= -1.

I want to make a macro that will go through this dataset, find anyone who answered "yes" (aka "1") to any of the 12 questions, select that person with all of their data, and put it on a new spreadsheet. I know I can sort the spreadsheet and do it manually, question by question, but the reason I'd like a Macro is because I want to reproduce this method in the future since I will be using this survey on thousands of more people.

Is this something that seems doable??

I seriously appreciate any and all help!!