Advanced Filtering

  • Thread starter Thread starter carlos
  • Start date Start date
C

carlos

Thank you "Debra Dalgleish" <[email protected]>
for helping me get my list into filtering shape.

I would now like to make the list easier for some of my
colleauges to use.

I was hoping to have cell A2 a data entry cell where they
could enter the Product Group (eg. "A"). I then would
like a copy of the resulted filtered list pasted in cell
E2 (eg. A,XAE,YA). I tried the Tools/Advanced Filter and
liked the results but am looking for a way to do this by
just typing in the Product Group into cell A2.


ProductGroup ProductType
A A
A XAE
A YA
AA AA
AA XAP
AA YJA
AAPL AAQ
AAPL WAA
AAPL ZAA
ABT ABT
ABT WBT
ABT ZBT
 
There's a sample file on my web site that uses an Advanced Filter to
extract data to a different worksheet. A macro that's triggered by a
worksheetChange event runs the filter. You could adapt this to filter to
a different range.

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Product List by Category'.
 
Back
Top