I have two tables with thousands of records, all of which on the one tab were given a "dupstat" if they were a duplicate. In this instance duplicate doesnt mean a duplicate in the sense of data duplicate, but a business processing duplicate. So my problem is, that when the items from tab a, were filtered and moved to tab b and the columns were limited, the rest of the data from tab a wasnt moved with it. All the work was done on tab b and I need to figure out a way to get the data back on to tab a somehow. I dont know how to do this if multiple rows can have multiple columns with similar data. Here are the data on the two tabs
TAB A:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Tab b
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
TAB A:
acct# | loan# | amt | total | diff | daydif |
9874561478 | 00510638521478 | 350.00 | 2,300.00 | 126.13 | 1 |
9874561478 | 00510638521478 | 1,726.13 | 2,300.00 | 126.13 | 1 |
9874561478 | 00510638521478 | 350.00 | 2,300.00 | 126.13 | 1 |
9631478520 | 00510638528520 | 1,354.34 | 2,055.00 | 55.00 | 2 |
9631478520 | 00510638528520 | 645.66 | 2,055.00 | 55.00 | 2 |
9514786320 | 00510638526320 | 6,975.14 | 6,975.14 | 0.00 | 1 |
8451623098 | 00510638523098 | 254.87 | 254.84 | 0.00 | 1 |
3691234567 | 00510638524567 | 653.00 | 1,000.00 | 178.00 | 1 |
3691234567 | 00510638524567 | 525.00 | 1,000.00 | 178.00 | 1 |
1234561478 | 00510638521478 | 874.45 | 900.00 | 875.4 | 1 |
1234561478 | 00510638521478 | 26.50 | 900.00 | 875.4 | 2 |
1234561478 | 00510638521478 | 874.45 | 900 | 875.4 | 4 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Tab b
acct# | amt | total | diff | daydif | dupeStat |
9874561478 | 350.00 | 2,300.00 | 126.13 | 1 | |
9874561478 | 1,726.13 | 2,300.00 | 126.13 | 1 | |
9874561478 | 350.00 | 2,300.00 | 126.13 | 1 | dupe |
9631478520 | 1,354.34 | 2,055.00 | 55.00 | 2 | |
9631478520 | 645.66 | 2,055.00 | 55.00 | 2 | |
3691234567 | 653.00 | 1,000.00 | 178.00 | 1 | |
3691234567 | 525.00 | 1,000.00 | 178.00 | 1 | |
1234561478 | 874.45 | 900.00 | 875.40 | 1 | |
1234561478 | 26.50 | 900.00 | 875.40 | 1 | |
1234561478 | 874.45 | 900.00 | 875.40 | 4 | dupe |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>