Filter only the columns based on another filter?

[jin3218]

hi all, i would really appreciate if someone can help me out with this. So i have 2 sheets, 1 sheet would have list of training needed for each profession and other sheet will have the names of all the people along with all the trainings. Now, in the 2nd sheet when I filter a certain profession, i want all the trainings that are not required for that profession to be hidden? example attached. If i select accountant in the profession in the 2nd sheet, i only want to see outlook and excel.

thanks

Also posted here Filter only the columns based on another filter?

 

[mamady]

This video tutorial will help you to achieve this

Regards
M. Yusuf