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!!!
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!!!