Suppressing Values in Autofilter Criteria List

[Brad Autry]

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

 

[Brad Autry]

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!