MACRO to filter based on DATE from a Column containing both time and date.

[arham_1987]

Hi Guys,

What I'm looking for is to have a macro which would do two things :-


1) A macro which looks at one column which contains date and time in "dd/mm/yyyy HH:MM:SS" , and irrespective of time, filters for the record corresponding to the start date and end date.

2)Since the source sheet is constantly changing,it should refresh the validation list to have only unique dates so that the user shouldnt have to go through a long list to select the start and end dates.


Any help is greatly appreciated

Regards,
Arham

 

[RJPotts]

1) A macro which looks at one column which contains date and time in "dd/mm/yyyy HH:MM:SS" , and irrespective of time, filters for the record corresponding to the start date and end date.

Do you mean that you want to specify the start date and end date as the filter criteria? I.e. that you're searching for entries that fall between two dates? How are you selecting / defining those dates?

2)Since the source sheet is constantly changing,it should refresh the validation list to have only unique dates so that the user shouldnt have to go through a long list to select the start and end dates.

Best regards
Richard