Find recent value by date

Run the below code which will ask you to select the column from which the duplicates needs to be removed.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Please explain what is going wrong when you run the code or what error is occurring?

Oops... really sorry for it since I have not considered Column-A in my previous code.

Try the below revised code...

Please Login or Register  to view this content.

Sorry.. If i have misunderstood the question.. but i think.. you want to keep only the Recent date's order to keep.. and you want to skip / delete.. old order's..

Try this..

Please Login or Register  to view this content.

test..
My post is not updating in parent forum..

Are you matching Two columns or single column for removing duplicate?

For single column use post #2 code
For Two columns use post #6 code

to keep only recent or Max of Date.. check post # 7..