User Select Macro to Change a Pivot Table

shelleydan

New Member
Joined
Aug 13, 2002
Messages
18
I have a pivot table with one data element, which could be #new, #tsf, #closed, or #accts. I want the user to select which of these data elements they want to review (macro button?) & have a marco that will automatically change the pivot table to report their selection.

Recorded code only works when you know what the current data element is. Can you tell me what I need to make this work?

As always...thanks for your help!!!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

TryingToLearn

Well-known Member
Joined
Sep 10, 2003
Messages
730
Consider a ComboBox or Drop Down List with your choice of elements that inserts the appropriate element in the pivot table.
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,447
Is it not possible that, within your pivot table, you add the elements you want to be able to select to a page field. This would then give you a drop down box to select from.
 

shelleydan

New Member
Joined
Aug 13, 2002
Messages
18
Thanks for the feedback! Unfortunately, it had to be the data field & I don't know how to do combo boxes. I did figure out some macros to use from reading thru lots of posted questions.

Thanks again for your help!
 

Forum statistics

Threads
1,186,156
Messages
5,956,254
Members
438,243
Latest member
FXA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top