ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Categories in Excel. (https://www.excelbanter.com/excel-programming/278173-categories-excel.html)

Dinesh[_2_]

Categories in Excel.
 
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.


-----Original Message-----
Dinish,

If you have one sheet that contains all the data, you
could create a report based on a filter list.
Then set the filter based on the user's selection.

I use that in several workbooks.

-----Original Message-----
Hello:

Is there a way to develop a category application in

Excel
that enables a user to select an item from that list of
categories? Furthermore, when the user selects that

item,
they would like to see a report pop up, displaying the
data associated to that list item. Is this possible? If
so, how can this be done, and how complex is this? I

hope
what I just said made sense.

Again, your help would be greatly appreciated.

Regards,

Dinesh.


.

.



All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com