Suppressing Values in Autofilter Criteria List
 

Hello,

I'm not a VBA guy, but I think what I'm trying to do can only get done with
some lines of code. Any help would be appreciated.

I've a fairly large data set that I'd like to be able to apply advanced
filters to. I would like the source table for criteria to update
automatically based on values from other criteria entered. For example:

Column A could be Region.
Column B could be job.
Column C could be Salary Grade.

I would like, should I choose East Region, for the list of possible jobs to
be then updated automatically to exclude any jobs that are not present in
East Region.

Or should I select salary grade 12, I would like the job selection criteria
drop down to only include jobs that are in grade 12.

I believe this is possible, but I can't make it happen.

Thanks in advance for any suggestions!

Regards,
Brad

Suppressing Values in Autofilter Criteria List
 

As an addendum to my first post:

I am not looking to create dependent drop downs that are linear in nature
(i.e., continent country region city, etc). I've found ways of using
Index or Offset to make subsequent drop down options limited. I am hoping to
find a means of making it so a user can select a drop down criteria at any
data field, and have the other criteria options update automatically.

Sorry if I was not explicit enough in my initial post.

Thanks!

"Brad Autry" wrote:

Hello,

I'm not a VBA guy, but I think what I'm trying to do can only get done with
some lines of code. Any help would be appreciated.

I've a fairly large data set that I'd like to be able to apply advanced
filters to. I would like the source table for criteria to update
automatically based on values from other criteria entered. For example:

Column A could be Region.
Column B could be job.
Column C could be Salary Grade.

I would like, should I choose East Region, for the list of possible jobs to
be then updated automatically to exclude any jobs that are not present in
East Region.

Or should I select salary grade 12, I would like the job selection criteria
drop down to only include jobs that are in grade 12.

I believe this is possible, but I can't make it happen.

Thanks in advance for any suggestions!

Regards,
Brad