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