B
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
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