• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change values in Pivot Table

S

Shay A

Member
Hi,
If I would like a to create a code to create a code to replace one measure with another and vice versa, will a simple recording do the trick? I want this code for a specific pivot on my workbook and not to the other pivot tables.

TY,
Shay
 
Whe you say measure? Do you mean column, row, filter or values?

Either way since its only 1 specific PivotTable you can record it and chage the bits you need to suit by using and IF formula with a Variable
 
I mean values of course, sorry. Ok I will try to recrord it. Not sure I would need a variable though.
 
You must log in or register to reply here.
Back
Top