Categories in Excel.

[Dinesh]

Hi Mick:

Thanks for your help. Let me clarify what I'm trying to
say. My question is how I can categorize data in Excel,
and build a report, based on the list of categories
available. Let me give you an example. Say I have a
category called Sports Activities, and there are two items
listed under this category: Indoor Sports and Outdoor
Sports. If the user wants to view a report, based on the
category Sports Activities, or a report on Indoor Sports
or Outdoor Sports, how can this be done? Can a Macro be
used for this? Or will this involve some VBA programming.

If you, or anyone else, can provide me some feedback on
this, it would be most helpful and appreciated.

Regards,

Dinesh.