Data set of people with multiple dates. VBA coding to remove all but most recent?

Hi all,

The data set that I'm working with lists Employees by First name, last name, hire date and termination date (as well as a bunch of other unrelated columns). Essentially, the data represents Dates of Employment for all employees of my company. It is not uncommon for employees to be terminated (adding a record of a hire date and a termination date to the list) and then coming back at a later date (such that they now have two records. One for their first record of employment, and now they are hired again, so there are two records under the same person). Is there a VBA code that will sort the employees by name and remove the dates that are not the most current? Any help would be greatly appreciated. Thanks.