View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jday Jday is offline
external usenet poster
 
Posts: 50
Default Set data filter based on user selections

I have a file that contains two user-defined lists. When the user sets
values for these lists & clicks a macro button, I want the macro to go to the
master data tab and filter the appropriate columns based on these values.
(From there, I have additional code that does something else with the
filtered data).

I am unsure how to construct the code that filters multiple items from a
list. Can someone lend some guidance on how to do this? (One other thing
in case it matters---the user list may contain anywhere from 1-100 items)