VBA Pivottables

Resolved · Low Priority · Version 2007

Thu 28 Oct 2010, 16:13 Delegate 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:05 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Hide columns in an Excel 2010 Worksheet

If 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.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips