Remove duplicates and change dates - VBA

[wrightyrx7]

Hi all,

I need to create a macro that will remove duplicates and leave everyone with one line. But dates will need to be amended before deletion of duplicates.

The ONE remaining line will have:-

1. The earliest Start date for each employee.

2. The greatest end date for each employee UNLESS the line with the greatest start date, has an end date that is BLANK (This means the record is still ongoing, and should remain BLANK).

Thanks in advance
Please see image/data for example.

Capture.JPG

Example Data.xlsx

[MickG]

Try this:-
Results start "E1"

Please Login or Register  to view this content.

Regards Mick

[stanleydgromjr]

wrightyrx7,

With your raw data already sorted/grouped by column A, per your workbook.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the RemoveDuplicatesPlus macro.

[wrightyrx7]

Hi Guys,

Tested them both and both work perfectly!!!

Thank you so so much this is a great help!

[stanleydgromjr]

wrightyrx7,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.