Hi all,
I have a specific question and hopefully one of you can provide me with the correct code - I can't write VBA on my own though and I haven't found the right code to tweak yet.
Problem (see attached file): I have a table (C12:I18) and I want to show certain columns based on a choice in one cell (B2). The matrix (C4:I7) states whether a column should be visible or not. One (1) means it is visible and zero (0) means it should be hidden. When I chosse 'All' in B2 then all columns are shown. When I choose 'Employment' then columns E and F should hide.
I need flexibility in terms of adding more columns to the table and certainly my choices will increase (so the matrix will increase).
Hope someone can help with code.
Thanks, David
Bookmarks