Good morning all...or evening if your on the other side of the world ha.

What I have is around 4000 lines of data, each with an employee name and a date (among other information) I would like to run a macro that will use a common key from one sheet, and select the most current employee from another using the common key from the first sheet. Attached is an example.

Find most Current Example.xlsx