Pivot Table Dynamic Reference Data
I already have a pivot table created using pivot table wizard. The layout for the pivot table is expected to remain unchanged. However, I am trying to write code that adjusts the reference source range to reflect the number of rows in the source range (located in a different worksheet). In other words, the only thing that is expected to change regarding pivot table and/or source data is number of rows. Can you assist? Thanks.
(By the way, I have seen several codes using the PivotCaches.Add method. However, I think it's an overkill for my purpose)