View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveT
 
Posts: n/a
Default Advance Filter update

Thanks for help with this...

I have 2 worksheets, 1 - data, 2 - billing sheet.
I am trying to use advanced filter on billing sheet to draw line items
specifics from sheet 1 if falls in data range user selects.

I'm trying to follow www.contextures.com/xladvfilter01.html which is helpful
but
my billing sheet will not re-filter if the criteria ranges are changed.

Can someone help to make this a dynamic sheet so user does not have to have
to "Advanced" in the area of advanced filtering to use?

thanks for your trusted help