Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - chart with text categories in X and frequencies in Y | Charts and Charting in Excel | |||
Excel chart categories.... | Excel Worksheet Functions | |||
Excel XP - How to assign Categories, Sub-Totals and Pie Charts | Excel Discussion (Misc queries) | |||
How can I collapse Excel data into categories? | Excel Discussion (Misc queries) | |||
Drop down categories in Excel | Excel Worksheet Functions |