phil152003
Board Regular
- Joined
- Mar 11, 2011
- Messages
- 89
I've spent all afternoon researching this and I'm no closer to a solution (I have very limited VBA knowledge, but this would be very VERY useful to me and the people I work with if I can get this to work, so any help is greatly appreciated).
I have a pivottable that feeds from an OLAP cube connection. The filter I use is in the following heirarchy:
ClientAccount > More fields > Account No.
(i.e. in the field selector on the right (I'm using Excel 2007) I click on the "+" next to ClientAccount, and then the "+" again next to "More fields", and then drag "Account No" to the filter section)
It is the "Account No" that I have as the filter. What I want to achieve is to have an input cell on the same worksheet where I can type in, for example "10345", and the pivot filter will automatically change to "10345" and the table will update automatically.
From my reading I believe this is feasible, if anyone could show me how this can be done I would be very greatful.
I have a pivottable that feeds from an OLAP cube connection. The filter I use is in the following heirarchy:
ClientAccount > More fields > Account No.
(i.e. in the field selector on the right (I'm using Excel 2007) I click on the "+" next to ClientAccount, and then the "+" again next to "More fields", and then drag "Account No" to the filter section)
It is the "Account No" that I have as the filter. What I want to achieve is to have an input cell on the same worksheet where I can type in, for example "10345", and the pivot filter will automatically change to "10345" and the table will update automatically.
From my reading I believe this is feasible, if anyone could show me how this can be done I would be very greatful.
