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