Macro To Build Custom Pivot Table

[dannybland]

Hi,

I want my workbook (2007) to contain a button that when clicked, pops up with a selection window for pivot table fields, is this possible?

I have a few buttons that create specific pivot tables but I also would like a button that would offer the user the chance to construct a custom PT if they so wish.

Thanks,
Danny

 

[Andrew Poulsom]

Doesn't Alt+d+p give you what you want?

 

[dannybland]

No, I want it to just give the options of field names and whether they are column, row, values or filters. So the data range has already been selected, but the user will be asked (hopefully with some type of prompt) which fields are needed. This is because this will be used across a company and not just by myself so I want it to be as user friendly as possible with as little work as possible for the user.

Danny

 

[Andrew Poulsom]

Why can't they use the Pivot Table Field List Pane? I don't see the point in reinventing it.

 

[dannybland]

The raw data sheet along with others will likely be hidden so there is just a dashboard screen that users interact with