Re: $$Excel-Macros$$ Macro for Autofilter

2015-01-03 Thread Vaibhav Joshi
Hi Use this code .. Sub Filter_Date() ActiveSheet.AutoFilterMode = False fDate = CDbl(Range("J1").Value) lDate = CDbl(Range("J2").Value) Range("A11").Select Selection.CurrentRegion.Select Set Rng = Selection Rng.AutoFilter Field:=3, Criteria1:="<=" & lDate, Operator:=xlAnd, Criteria2:=">=" & "" &

$$Excel-Macros$$ Macro for Autofilter

2015-01-02 Thread Ashish Bhalara
Dear experts, Please provide Macro for autofilter for criteria of Date range & exact matching of code as per in attached sheet. Column of C contain date and filter as per range given in J1 to J2. Second filter on column D with exact match in cell J4. Regards. Ashish Bhalara 9624111822 P*Please do