I have an excel sheet. It is so setup that in Column A all states are
mentioned (they are Bold and shaded)...under each state there are some sub
categories...(could be different in each state)...In Column B to Column J
there is some data related to the sub categories....

Problem : It is a huge sheet and sometimes it becomes difficult to compare
data as whole of the data is not needed all the time.

Requirement : I want to get around it with some automation...that user may
be given some choices to pick the states and and columns it wants to see and
only the required data may be printed.

I don't want to name the ranges as sub categories/data often changes.....

I was thinking to populate the listbox with the Bold shaded heading in
Column A and give user the option to select the required only....similarly
giving users the option to select the required column....and hence the
unrequired is hidden.

But i am not aware how to accomplish it. Could anyone suggest me a different
Logic and/or wayout to do it. Suggestions will behighly appreciated.

--
Ajit