Is there a way to create/automate a Pivot table using VBA. I am trying to sum/display all sales data for all employees by month. The range of the data sheet will have to depend on whatever is in the data sheet since it will constantly be updated. So there could be 10 lines of 100 lines so the pivot table would need to account for all that.

Thanks