Select and COPY cells according to DATE

[Pana1]

Hello!

I have a column (A) full of dates. Certain dates repeat themselves. There are additionnal informations in the neighboring cells.

I need a macro that searches for the most recent date, selects the entire corresponding ROWS and copies them to a new workbook.

Could you please me ?

Thank you very much !

Cheers

[venkat1926]

ambiguous. there can be only one recent date. If you are thinking rows of identical data there cannot be any recent date as all of them are same date. Rephrase your question. or post a small portion of your sheet and explains with examples

[royUK]

Why not just use a PivotTable?