VB macro for sorting through scores and copying certain scores to new sheet

So I tried to get this figured out earlier today, and even had some help from Blake over in the general forums but to no avail we're still stuck.

http://www.excelforum.com/excel-gene...rt-filter.html

^ original thread if you want to reference it.

I have an idea on the logic behind the code, but I'm not sure on the syntax to write it.

Basically the module would do a find function which would locate "100", using something similar to Ctrl+F's Match Entire Cell Contents ability. Upon finding the value, it would copy the value(100), the number in the cell directly to the left of it (which is the scores corresponding time), and paste those into a new sheet with the same header they were under in the previous sheet. After finding the first value of 100 in a column, the module would begin to process the next-next column over (every-other one). If a score column didn't contain 100, it simply gets skipped over.

I know there's going to be some IF logic in there but it's been about 4 years since I've coded so I know it'll be rough trying to write out the syntax for it.

In short I need to sort every-other column (the score columns) to figure out in which cases a participant hit 100, and if they did I need the time which they hit 100.

I've tried using a table and pivot table to do this but in both cases it's just pointing and clicking through the various values and with a master document of about 12000x400 its taking dreadfully long.

I've attached a a document with a small portion of the data. If any of the VB guru's out there can help you guy's would be life savers.

Perfect. I was able to use the remove duplicates feature to knock out the multiple occurrences of 100 within a single score.

Got it all set now. Thanks a ton.