Autofilter using range from another sheet as the criteria

R

Robert

Hey Guys,

I need some help with dynamic autofiltering. Here's a quick example.

Sheet 1:
Name Type Color
Apple Fruit Red
Banana Fruit Yellow
Cheese Dairy Orange
Chicken Meat White
Milk Dairy White
Eggs Meat White
Vitamin Pill Tan

Sheet 2:
Criteria (for Type): <== this is a dynamic list that grows and
shrinks!
Fruit
Dairy
Meat

How do I autofilter Sheet 1's type using the range on Sheet 2? Keep
in mind that it has to be dynamic -- there is no way to know if the
types in the Sheet 2 criteria range will be 3 items or 30...

I tried putting the range directly in and it crashes Excel 2007 (which
is awesome by the way).

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use mouseclick to dynamically change chart series? Chart_beforeDoubleClick? 2
Dynamic Named Range formula without using OFFSET function 5
Evaluating criteria within certain columns 2
Column range to search from a source workbook and then copy/paste 0
xl2002 - AutoFilter from Criteria from Other Sheet... 2
Autofilter multiple criteria using array 3
referencing another worksheet / passing name from curr. sheet 3
Match a cell in a range to a value from another sheet and select r 3

Top