Pivot Table user form

[geolefty]

Is there a way to provide a nice looking user form/interface (ie. pull down menu, radio buttons, etc.) for a client to generate a pivot table. I am looking for something other than the pivot table wizard.

For example, on the user form (interface) the user selects animal, color, weight and count of weight and a pivot table is generate from the source data?

thanks

 

[Juan Pablo González]

Sure, there's a way. But, you have to create everything... that is, almost simulate the Pivot Table wizard. Basically, you just need to create your own Userform with the way you want it to appear, and create the Pivot table entirely from code.