I am complete lost on this one and hoping for some assistance.
I have a workbook with sheet1 and sheet2. In each sheet, the comparable data in located in column A. I would like a code that compare and match the sheet 1 data against sheet2. The results would be located on sheet3 with the percentage match.
Thanks in advance.
Example:
Sheet 1
<TBODY>
</TBODY>
Sheet2
<TBODY>
</TBODY>
Sheet3: Results
<TBODY>
</TBODY>
I have a workbook with sheet1 and sheet2. In each sheet, the comparable data in located in column A. I would like a code that compare and match the sheet 1 data against sheet2. The results would be located on sheet3 with the percentage match.
Thanks in advance.
Example:
Sheet 1
HEADER |
tommy123 |
peters |
susan6783 |
edwards |
<TBODY>
</TBODY>
Sheet2
HEADER |
tommy122 |
susan6733 |
peters |
edwards123 |
<TBODY>
</TBODY>
Sheet3: Results
HEADER 1 | HEADER2 | PERCENTAGE MATCH |
tommy123 | tommy122 | 87.5% |
peters | peters | 100% |
susan6783 | susan6733 | 88.89% |
edwards | edwards123 | 70% |
<TBODY>
</TBODY>