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.
^ 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.
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.