Extracting specific data from an XLS survey answer sheet

[jsad]

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!!

[watersev]

hi, jsad, any chance to see sample workbook with original data and result you'd like to obtain

[jsad]

Hmmm....data might be sensitive, but I can make a similar sample spreadsheet. Let me get working on one and then upload. Thanks for the interest!

[jsad]

Okay I've made a sample sheet...the fields that are in yellow are the survey questions (I guess there were 9, not 12).

So what I wanted to happen is: a macro selects all the people who have a "1" in any of the 9 questions, takes their entire row of info (name, gender, all 9 questions, all that random data afterwards) and puts them in a separate spreadsheet.

Is this something feasible/possible?

[watersev]

hi, jsad, please check attachment, run code "test"

[jsad]

Wow!! That was awesome, watersev!

Is there any way to put all of the selected patients onto one spreadsheet, instead of on seperate sheets?

Thank you SO much for your help.

[watersev]

please check attachment, run code "test"