I need a macro to match/find Rep list and ID on Sheet 1 with Sheet 2 then copy and paste Skill Level from sheet 2 under the correct Skill on Sheet 1. I have a list of over 300 Reps and about 20 different skills and each skills has a levels ranging from 1-8. Below is a quick a example of how sheet 1 should look after comparing the list matching and copying the value from the Data to sheet 1. Sorry I don't know how to add the grid lines but Rep name is A3 and so on.
<tbody>
</tbody>
Sheet 1 | |||||||
Rep Name | Rep ID | 1510 | 1511 | 1512 | 1516 | 1517 | 1688 |
Rep 1 | Rep ID 1 | 6 | 1 | 2 | |||
Rep 2 | Rep ID 2 | 4 | 3 | 5 | |||
Rep 3 | Rep ID 3 | 5 | 3 | 2 | |||
Rep 4 | Rep ID 4 | 3 | 4 | 1 | |||
Rep 5 | Rep ID 5 | 3 | 1 | 1 | |||
Sheet 2 Data Sheet | |||||||
Rep Name | Rep ID | Skill01 | Skill01 Lvl | Skill02 | Skill02 Lvl | Skill03 | Skill03 Lvl |
Rep 1 | Rep ID 1 | 1517 | 1 | 1688 | 2 | 1516 | 6 |
Rep 2 | Rep ID 2 | 1510 | 4 | 1511 | 3 | 1512 | 5 |
Rep 3 | Rep ID 3 | 1688 | 2 | 1516 | 3 | 1510 | 5 |
Rep 4 | Rep ID 4 | 1516 | 1 | 1510 | 3 | 1512 | 4 |
Rep 5 | Rep ID 5 | 1511 | 3 | 1517 | 1 | 1688 | 1 |
<tbody>
</tbody>