Help me create macro.
Compare Sheet2 with Sheet1, IF match paste result into sheet1.
Sheet 1:
<tbody>
</tbody>
Sheet 2:
<tbody>
</tbody>
Compare Sheet2 with Sheet1, IF match paste result into sheet1.
Sheet 1:
| 1 | a | b | c | d | e | f: Result |
| 2 | Name | John | Name | Name | Name | John |
| 3 | Paula | Name | Name | Name | Name | Paula |
| 4 | Name | Name | Rick | Name | Name | Rick |
| 5 | Name | Name | Name | Name | James | James |
| 6 | Frank | Name | Name | Name | Name | Frank |
<tbody>
</tbody>
Sheet 2:
| 1 | a |
| 2 | John |
| 3 | Paula |
| 4 | James |
| 5 | Rick |
| 6 | Hans |
| 7 | George |
| 8 | Frank |
<tbody>
</tbody>
