Hi,
There are 2 types of query under query type that is Benefits & HR Operation , when I select any one, under sub query type only the queries should display that belongs to query type. I have done this. But when I select query type as “benefits” and sub query type as anything as in the table then in last column under “call activity” all call activity should display (activities like – inbound, outbound, Outbound or VM call back, VM Retrieval, Forwarded to CAST, Escalated to ABC, Escalated to XYZ)
Attached the sample sheet for your reference. if possible do it with this sheet and post it.
Thanks!
Last edited by anwitha; 07-27-2011 at 02:02 PM.
how is column c dependent on sub query type?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Yes..my issue is if I select any sub query in column D under benefits then in Column E all the Call/Activity type should display. but ACW & Email should not display since its comes under HR Operations.
I've added a second named range for each group that covers the column E choices, and edited the Data Validation for the Call/Activity section to use the second range.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hello Anwitha,
See the attached. Moved the validation entries in to a new sheet. You can Add/Delete Query/SubQuery/CallActivities.
See the attached.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Dear both..
Thanks a lot for your help.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks