Data Validation & Filtering Lists

  • Thread starter Thread starter Vacuum Sealed
  • Start date Start date
V

Vacuum Sealed

Hi all

As the Subject suggests.

Is there a way to filter a Data Validated list, or would I have to switch
over to a cboBox and apply the filters to that instead.

eg..

Name..........Group..........Active
Jack 1 Y
Jill 1 N
Peter 2 Y
Paul 2 Y
Mary 2 N

So when using the auto-filter on the NamedRange attached to the name column
in Sheet2, I would like to filter out the "N" active, and say select only
Group 2 members; so that when the dropdown list on Sheet1 is opened, it only
displays the active members.

Not sure if Barbara Dalgleish's Contextures DataValidation example
will/would fit the bill, that said...! While I am awaiting your feverish
responses, I 'll go sus it out and report back.

Looking forward to your thoughts and comments.

TIA
Mick
 
Gotta love it when you rush and click post before vetting your dribble
first...

Sorry Debra.....Oops...!!!!

:P
 
I found this on Deb's site that may suit my needs.

Excel Data Validation -- Create Dependent Lists With INDEX

Will have a go at that and report back.

Cheers
 
Hi all

Diregard this post as I found that the Setup on Deb's site is perfect for my
needs.

Cheers
 

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

Get/Find criteria and copy sum 2
Using Filter List to set Chart Symbol, data labels etc 1
setting more than one filter 1
RangeName Define Limitations 9
filtering two pieces of data 3
Referencing data validation list in IF Statement 2
Data validation dependent on value in another cell. 2
Help required to select a cell in a filtered list 1

Back
Top