Hi guys,
I need help autofilter a table based on a high and low range determined by another sheet. below is the macro i recorded...

Selection.AutoFilter Field:=6, Criteria1:="<26", Operator:=xlOr, _
Criteria2:=">23"

say the data table is on sheet2, what i need is to filter the table to show data between the values of sheet1 cell a1 and sheet1 cell a2.

thanks