Dear all,
I have a couple of sheets that consist out of several pivots. These pivots are standardized and the user can't change anything to them exept the filter value. Now i added an extra sheet where the user can expirement himself with a pivot table. Now i want the user to be able to copy the filter and field options etc to that extra pivot on the extra sheet, so he or she doesn't have to add all the options theirselves.
I guess that i macro can help me. I have got a macro that erases all the filters and fields, but now i want one to copy and add filters and fields. Is this possible?
Just let me know if clarification or more information is needed.
I have a couple of sheets that consist out of several pivots. These pivots are standardized and the user can't change anything to them exept the filter value. Now i added an extra sheet where the user can expirement himself with a pivot table. Now i want the user to be able to copy the filter and field options etc to that extra pivot on the extra sheet, so he or she doesn't have to add all the options theirselves.
I guess that i macro can help me. I have got a macro that erases all the filters and fields, but now i want one to copy and add filters and fields. Is this possible?
Just let me know if clarification or more information is needed.