Hello , I need your help please
I have very large database file about 100000 rows and 20 column , sample example as follow
<tbody>
</tbody>
I need to have VBA code to look up the value in Column A and then search for the most recent date in Column B corresponding to this value , and then add the work “ current “ in the adjacent cell for this date and “ superseded” to the old date
Hope my request is clear
I have very large database file about 100000 rows and 20 column , sample example as follow
| Column A( Name) | Column B( Date) | Column C ( Status) |
| 15600-DP-C-01452 | 4/10/2017 | Superseded |
| 15600-DP-C-01452 | 5/11/2017 | Current |
| 15600-DP-C-01452 | 1/25/2017 | Superseded |
| 15600-DP-C-01452 | 2/28/2017 | Superseded |
| 15600-DP-C-02345 | 3/07/2017 | Superseded |
| 15600-DP-C-02345 | 1/24/2017 | Superseded |
| 15600-DP-C-02345 | 1/12/2017 | Superseded |
| 15600-DP-C-02345 | 4/13/2017 | Current |
<tbody>
</tbody>
I need to have VBA code to look up the value in Column A and then search for the most recent date in Column B corresponding to this value , and then add the work “ current “ in the adjacent cell for this date and “ superseded” to the old date
Hope my request is clear
