Need Help: Changing Date Formatting, Filter Unique Value, Sort

[khaledocom]

Hi all,

I need a VBA code to do above mentioned in the attached file.


Thankful for your help.
Book1.xlsxBook1.xlsx

[dxider]

1.-
=LEFT(A1,2) & "/" & RIGHT(LEFT(A1,5),2) & "/" & RIGHT(A1,4)

2.- Select Data>Filter>Advanced Filter and check the checkbox.

3.- Select Data>Sort.