Hi All,
I am new to this forum and looking for some assistance for creating a macro for a process that takes me about a day to complete. Any help would be greatly appreciated. And Thank you in advance!
Below is the table:
<TBODY>
</TBODY>
What I currently do manually is look at the ProviderName and look for the names that matches, then I look at the DateOfService and look for the dates that matches. When those two criteria are met, I would add matching numbers to the column call Pairing. What I want the macro to do is automatically add the matching numbers for me in the Pairing Column. Below is the result.
<TBODY>
</TBODY>
I am new to this forum and looking for some assistance for creating a macro for a process that takes me about a day to complete. Any help would be greatly appreciated. And Thank you in advance!
Below is the table:
ProviderName | TotalCharge | DateOfService | Pairing |
John Smith | 120.00 | 1/1/11 | |
Michael Dean | 130.00 | 2/1/11 | |
John Smith | 60.00 | 1/1/11 | |
Michael Dean | 50.00 | 2/1/11 | |
John Smith | 45 | 1/1/11 |
<TBODY>
</TBODY>
What I currently do manually is look at the ProviderName and look for the names that matches, then I look at the DateOfService and look for the dates that matches. When those two criteria are met, I would add matching numbers to the column call Pairing. What I want the macro to do is automatically add the matching numbers for me in the Pairing Column. Below is the result.
ProviderName | TotalCharge | DateOfService | Pairing |
John Smith | 120.00 | 1/1/11 | 1 |
Michael Dean | 130.00 | 2/1/11 | 2 |
John Smith | 60.00 | 1/1/11 | 1 |
Michael Dean | 50.00 | 2/1/11 | 2 |
John Smith | 45 | 1/1/11 | 1 |
<TBODY>
</TBODY>