ARUNCHENNAI
Board Regular
- Joined
- Apr 24, 2017
- Messages
- 66
Hi,
I have 4 columns of data.
Time(24Hrs HH:MM), Item,Date(DD MMM YYYY)
Wish to use filter and extract data with certain criteria
1. ">=" & 20:00 Hrs 15 Mar 2018
2. "<=" & 10:00 Hrs 18 Mar 2018
Kindly support me with Macro code.
I'm using the below code, but no use
I have 4 columns of data.
Time(24Hrs HH:MM), Item,Date(DD MMM YYYY)
Wish to use filter and extract data with certain criteria
1. ">=" & 20:00 Hrs 15 Mar 2018
2. "<=" & 10:00 Hrs 18 Mar 2018
Kindly support me with Macro code.
I'm using the below code, but no use
Code:
source_sheet.Range("A:D").AdvancedFilter _
Action:=xlFilterInPlace, _
CriteriaRange:=reff_sheet.Range("E1:H2"), _
Unique:=False
Last edited: