Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba pivottables

ResolvedVersion 2007

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

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.