Slicemahn
06-15-2009, 12:07 PM
Hello Everyone!
i need a second pair of eyes to figure where I have gone wrong in my coding. I have attached a worksheet that is to be used as a datasource for call information. There is a very important reason why it is in this form as opposed to a pivot table or filter list: It all comes down to data integrity!. Having said this, I have dropdown lists on the Report tab that will select the Vice-President and then the corresponding list of Call Centres. I am challenged in two areas:
(1) The data validation lists only allow for me to filter for Vice_President, Call_Centre and Director. It does not allow for the other two categories Sr. Manager and Team Manager.
(2) After selecting the Vice_President there is a runtime 1004 error : Application-defined or object error.
I cycled through my code without the luck in finding what is causing the error. I am hopeful that one of the experts in this forum may find and inform me of my wayward coding.
Many thanks,
Slice
i need a second pair of eyes to figure where I have gone wrong in my coding. I have attached a worksheet that is to be used as a datasource for call information. There is a very important reason why it is in this form as opposed to a pivot table or filter list: It all comes down to data integrity!. Having said this, I have dropdown lists on the Report tab that will select the Vice-President and then the corresponding list of Call Centres. I am challenged in two areas:
(1) The data validation lists only allow for me to filter for Vice_President, Call_Centre and Director. It does not allow for the other two categories Sr. Manager and Team Manager.
(2) After selecting the Vice_President there is a runtime 1004 error : Application-defined or object error.
I cycled through my code without the luck in finding what is causing the error. I am hopeful that one of the experts in this forum may find and inform me of my wayward coding.
Many thanks,
Slice