Pivot Tables With Vba

  • Hi,

    I have the below code which will create a pivot table. Now suppose my data gets updated and i want a new pivot table but in different sheet it gives me error with table destination (may be because the name is similar).

    Also will the code be able to identify the source data.


  • Re: Pivot Tables With Vba


    you might find it more flexible to use VBA in the form below, rather than a recorded macro. This code will create a Pivot Table based on the data in the ActiveSheet, given that you identify the sources of the Rows,Column, Pages and Data.

    Each time this is run a new Pivot will be created in a new Sheet

    If you were to post your workbook containing the data I could fill in the headings etc.



Participate now!

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