Create your summary pivot tables using the named range as a source.
In the worksheet events for the source pivot table, I put the following code: Private Sub Worksheet_Pivot Table Update(By Val Target As Pivot Table) 'Update the address of the named range This Workbook.
I have a Pivot table in excel that is using a raw table as its data source.
As a simple example, I create a new worksheet in a new workbook and name the sheet "January".
I'd like to now use the result of this new pivot table as the data source for a new pivot table which will further modify this data. I suppose you could call it 'nested pivot tables' In a new sheet (where you want to create a new pivot table) press the key combination (Alt D P). Display Alerts = True End Sub I guess your end goal is to show Distinct (unique) values inside your original Pivot table.
In the list of data source options choose "Microsoft Excel list of database". For example you could have data set with Order Number, Order Date, Order Item, order Qty First pivot table will show you Order Date and sum of Order Qty and you probably want to see Count of unique orders in the same Pivot.
If you change the size of your data set by adding or deleting rows/columns, you need to update the source data for the pivot table. This way your data source will be updated automatically when you add or delete rows/columns.
Tip: change your data set to a table before you insert a pivot table.
I can enter January sale data, and create a Pivot Table based on the data, by selecting the data range.