PC Review


Reply
Thread Tools Rate Thread

Autofilter using range from another sheet as the criteria

 
 
Robert
Guest
Posts: n/a
 
      23rd Jun 2009
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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoFilter Criteria using named range Len Microsoft Excel Programming 4 6th Sep 2010 10:41 AM
Selection.AutoFilter Field / Criteria => criteria sometimes non-existing on worksheet markx Microsoft Excel Programming 1 24th Nov 2006 02:52 PM
xl2002 - AutoFilter from Criteria from Other Sheet... =?Utf-8?B?VHJldm9yIFdpbGxpYW1z?= Microsoft Excel Programming 2 12th Sep 2006 05:41 PM
SUMIF: Criteria range is from other sheet and problem occurs mohitmahajan Microsoft Excel Misc 3 13th May 2004 05:16 PM
Use sheet name as search string or autofilter criteria Magar Microsoft Excel Programming 1 14th Nov 2003 01:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:47 AM.