Macro that triggers off a combo box

[doug1]

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?

[Jim Rech]

Have you looked a Data, Filter, AutoFilter? With or without VB experience
this may be the way to go.

--
Jim
"doug1" <[email protected]> wrote in
message news:[email protected]...
|
| 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
|

[doug1]

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.