I am trying to figure out how I can filter data from a specified range. What
I am specifically trying to do is similar to auto filtering. I have a large
inventory list and I can get the same items from different vendors. Example:
Column 1 = Stock Item, Column 2 = Vendor 1, Column 3 = Vendor 2, Column 4 =
Vendor 3 etc. What I want to do is be able to filter a vendor name across
those vendor columns and have it show the products I can get from the vendor
I chose. The auto filter will only filter the vendor and products in that
column, but the vendor could be in any of the vendor columns and I need it to
find the vendor wherever it appears. Is there a way to accomplish this in
excel 2003. Thanks