Hiding varied columns based on the value of one cell

All,
I have a multi-audience spreadsheet that has a lot of basic and technical knowledge on it.
I would like for the user to select their role from a name list drop down (created).
If they choose Developer all rows/columns are visible
If they choose Transitions columns K-Z are hidden.
If they choose Desk column F and K-Z are hidden.

I've tried my own Frankenstein monster of a script but it only works for Transitions and does nothing but select for Desk.

Please Login or Register  to view this content.

Any help would be appreciated, especially if I could get a little info on the correct script as I will likely need to edit this as it goes through all three departments and 7 managers for revisions.

Nailed it.
Thanks for cleaning up my ...we''ll call it code (ie context of the multi columns and the completely-made-up-by-me useless code)