troubleshooting Question

VBA to Update status Column based on recent date

Avatar of M. Saad
M. Saad asked on
VBAMicrosoft OfficeMicrosoft Excel
18 Comments1 Solution266 ViewsLast Modified:
Hello , I need your help please

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

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
Rev_Status.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros