98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Pivottables
VBA Pivottables
Resolved · Low Priority · Version 2007
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
Wed 3 Nov 2010, 10:05Trainer Jacob said...
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@stl-training.co.uk
Kind regards
Jacob
Tue 9 Nov 2010: Automatically marked as resolved.
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. |
Excel tip:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
