Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro that triggers off a combo box
hello, Needing some direction. I have a relatively straight forward list of data within Excel, which is used to create some managment reports. The data is broken down by department, subdepartment and then the relevant data by month. My though is to use a Combo Box that triggers the department to either hide all the non-relevant departments or only view the relevant department. Herein lies, my problem...how can I get this to work...is it even possible? I am not an experienced in Visual Basic, so my knowledge is limited when it comes to writing script. Are there any thoughts on how I should go about this? -- doug1 ------------------------------------------------------------------------ doug1's Profile: http://www.excelforum.com/member.php...o&userid=30746 View this thread: http://www.excelforum.com/showthread...hreadid=504162 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro that triggers off a combo box
Have you looked a Data, Filter, AutoFilter? With or without VB experience
this may be the way to go. -- Jim "doug1" wrote in message ... | | hello, | | Needing some direction. I have a relatively straight forward list of | data within Excel, which is used to create some managment reports. The | data is broken down by department, subdepartment and then the relevant | data by month. My though is to use a Combo Box that triggers the | department to either hide all the non-relevant departments or only view | the relevant department. Herein lies, my problem...how can I get this | to work...is it even possible? I am not an experienced in Visual | Basic, so my knowledge is limited when it comes to writing script. Are | there any thoughts on how I should go about this? | | | -- | doug1 | ------------------------------------------------------------------------ | doug1's Profile: http://www.excelforum.com/member.php...o&userid=30746 | View this thread: http://www.excelforum.com/showthread...hreadid=504162 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro that triggers off a combo box
Thanks for the input, I was beginning to play around with the Advanced Auto Filter, as I agree, it may be the way to go. Thank you for the advice.;) -- doug1 ------------------------------------------------------------------------ doug1's Profile: http://www.excelforum.com/member.php...o&userid=30746 View this thread: http://www.excelforum.com/showthread...hreadid=504162 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |