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