Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Pivottables
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA Pivottables
Resolved · Low Priority · Version 2007
Reply Thu 28 Oct 2010, 16:13Delegate Ian said...
Ian has attended:
Excel VBA Intro Intermediate course
VBA Pivottables
Dear Best STL,
Is there any way using VBA to update the filters on a pivottable from another worksheet.
Ideally I want a combo box on a front end worksheet which updates the pivot table and brings back one selected record.
Thanks
For upcoming training course dates see: Pricing & availability
RE: VBA Pivottables
Hi Ian
Thanks for your post, I have managed to check this with one of my colleagues who trains Excel VBA and they say this is certainly achievable but to design a solution and explain it is beyond the reach of this forum.
In these instances we would ask you to send through any working files you have with a brief specification of what you are trying to do. We will get back to you with a scope of work including durations and associated costs.
If you would like to discuss this further please email me at jacob
Kind regards
Jacob
Tue 9 Nov 2010: Automatically marked as resolved.
|