Please help me to create a VBA code that will do the following:
In column D, data is given in dd.mm.yyyy format. Data is sorted ascending but not consecutive. Using a VBA code, I want in the cell E2 (where is the validation date) to have the years for those data, (single years), and in cell F2 to choose all the data in column D for the year chosen in E2.
Thank you in advance.