Pivot Table changing sum values using VB

  • I have a pivot table that i am trying to copy out to another sheet.


    A note of clarification.
    My variables are used in the sum field - I have 70 different columns of data, that I want to use in combination one column field and one row field. So each time I'm changing the sum calculated by add a new sum and remove the previous one.


    I've tried to record the procedure to highlight a new variable and remove the previous. However it doesn't seem to work. Any suggestions gratefully received.



    I enclose my code below.


  • Re: pivot tables turning variables on off


    Giorgio, is there any specific reason why you posted the same thread twice within 9 minutes of each other? I am locking the other thread for the time being to prevent anyone answering an older version of your question...


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!