That is somewhat clearer. We can understand what you want now.

This is larger than I have time to help on right now. If no-one has come up with a solution in a couple of days then I might be able to have a go at it. To help with terminology, I would be expecting you want a userform with a multi-select listbox listing all the headings and the macro would hide any unselected (outlined) ranges.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia