Custom Data Transfer

[mweick]

Before I begin, I have attached a copy of the workbook for testing and explanation purposes.

We recently got a new glove testing machine and it kicks out an excel workbook to capture the data after running a test. When you open the workbook you will see two sheets: Data and Customer.
Each test can handle up to 10 gloves, so 5 pairs essentially. The first sheet called Data is the raw data that the machine pours over into the workbook; each row consists of one test and can be up to 10 gloves like I said before. The second sheet is an example of what the customer will get when finished. So basically:

On the Data sheet, in columns W, Y, AA, AC, AE, AG, AI, AK, AM, and AO there will either be BYPASS, PASS, or FAIL. I need a macro that can say if there is PASS or FAIL in any of these columns then transfer that word over to the customer sheet. If it says BYPASS in any of these columns then the macro should skip it and not bring it over to the customer sheet. On the Data Sheet, columns W, AA, AE, AI, and AM should be transferred over to the Customer Sheet in column G starting with row 11 and down. On the Data Sheet, columns Y, AC, AG, AK, and AO should be transferred over to the Customer Sheet in column H starting with row 11 and down. Now on the customer sheet each PASS/FAIL that get brought over needs to go on the next line so there should never be a PASS/FAIL in the same row on the customer sheet. We don't want this to happen automatically either, the macro should be linked to the Transfer Data button on the Customer Sheet.

If I missed anything or any questions arise please ask I respond very quickly!

I would appreciate any help on this!