Create list of selected criteria in auto-filter range

  • Thread starter Thread starter jday
  • Start date Start date
J

jday

I have a table in Range B3:H1000, with row 3 containing the headers &
autofilter. In a separate table, I would like to capture the filter criteria
selected by the user for each of these 7 columns. For example, if the user
chooses "Apples", "Bananas", and "Pears" in column B, there may be multiple
records for each of these. I would like the table to capture each of these
unique values only once. Same for column C - H values. Any ideas?
 
What do you want to do with the captured unique values?
How do you want it to look?
 
Ideally, I would like them to populate a smaller table that shows each unique
value under the respective column in a contiguous range. For example, if
there were 3 columns, I would want the unique filter values to populate like
this:

DEPT POSITION LEVEL
--------- ---------- ---------
Sales Manager 1
Marketing 2

This table can populate on the same page or a different page, I can work
around that either way. I was thinking about writing code that would take
the filtered report, copy/paste the entire range onto another tab & remove
the 'duplicate' values across each column independently. Didn't want to go
down that path if there was an easier method. Any insights would be
appreciated!
 
Back
Top