Create multiple pivot tables and charts for a Database that works with a Macro

  • Hi guys, I have this excel file with some data in sheet1 (this data is collected running a Macro) and I need to create multiple pivot tables and pivot charts embedded with the data in Sheet1 (the idea is that the pivot tables and the charts change with respect to the data in sheet1), but I am very lost, I am trying to write a code to create a single Pivot Table but It did not work and also I do not know if that is the best way to create multiple tables and charts.

    The code I was using to create a pivot table is the following, but gives me an error in "Source Data"

    Maybe someone can help me with some advice or help, thank you.

Participate now!

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