Hi,
I need some help I know, it's possible to use macro to filter data from one column actualy I use this type of code to filter one specific data from one column
With this code I can took all the data with the time 5 AM from the column, And It works. But in my data sheet on this column i have a bunch of time data. I want a macro to filter only data between 05:00 AM to 00:00 AM. Is possible to tell that with AutoFilter ?
I need some help I know, it's possible to use macro to filter data from one column actualy I use this type of code to filter one specific data from one column
VBA Code:
Sheets("Sheet_1").Range("A1").AutoFilter Field:=1, Criteria1:="05:00"
With this code I can took all the data with the time 5 AM from the column, And It works. But in my data sheet on this column i have a bunch of time data. I want a macro to filter only data between 05:00 AM to 00:00 AM. Is possible to tell that with AutoFilter ?