SCP Macro Project 2.0

Job ID: 34387746

Budget: $15 – $25 USD

Looking to create a macro in the "Working File" tab to do a Vlookup that will copy the order number in column D then go to the "Score Report" tab to column I to match the order number. If it matches, move 1 column to the left and If the value equals "ROOE", "ROA", "ROO", or "ROGB" then move 7 columns to the left and copy the value in column A and return that value (badge number) to the "Working File" tab column D. If the value doesn't match, skip to the next row and repeat.