software

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 quot;Advancedquot; in the area of advanced filtering to use?

thanks for your trusted helpYou can use programming to apply the advanced filter after the criteria
change. There are examples he

www.contextures.com/excelfiles.html

Under Filters, look for 'Filter for Date Range' and 'Product List by
Category'

SteveT wrote:
gt; Thanks for help with this...
gt;
gt; I have 2 worksheets, 1 - data, 2 - billing sheet.
gt; I am trying to use advanced filter on billing sheet to draw line items
gt; specifics from sheet 1 if falls in data range user selects.
gt;
gt; I'm trying to follow www.contextures.com/xladvfilter01.html which is helpful
gt; but
gt; my billing sheet will not re-filter if the criteria ranges are changed.
gt;
gt; Can someone help to make this a dynamic sheet so user does not have to have
gt; to quot;Advancedquot; in the area of advanced filtering to use?
gt;
gt; thanks for your trusted help
gt;Debra,

thanks, appreciate your site... most helpful.

B-Rgds, StevenT
quot;Debra Dalgleishquot; wrote:

gt; You can use programming to apply the advanced filter after the criteria
gt; change. There are examples he
gt;
gt; www.contextures.com/excelfiles.html
gt;
gt; Under Filters, look for 'Filter for Date Range' and 'Product List by
gt; Category'
gt;
gt; SteveT wrote:
gt; gt; Thanks for help with this...
gt; gt;
gt; gt; I have 2 worksheets, 1 - data, 2 - billing sheet.
gt; gt; I am trying to use advanced filter on billing sheet to draw line items
gt; gt; specifics from sheet 1 if falls in data range user selects.
gt; gt;
gt; gt; I'm trying to follow www.contextures.com/xladvfilter01.html which is helpful
gt; gt; but
gt; gt; my billing sheet will not re-filter if the criteria ranges are changed.
gt; gt;
gt; gt; Can someone help to make this a dynamic sheet so user does not have to have
gt; gt; to quot;Advancedquot; in the area of advanced filtering to use?
gt; gt;
gt; gt; thanks for your trusted help
gt; gt;
gt;
gt;