Hi,
I'm trying to create a macro where I have a pivot and the data source is always going to be dynamic; the row numbers can always change with each run.
I tried to create a table name with the data source and reference this table name and refresh the pivot. But this works only after I start creating the pivot and then add new rows of data.
In my case, my data source is always different from the beginning (varying number of rows), so I want it to automatically pick up the number of rows before I create the pivot.
Any suggestions?
I'm trying to create a macro where I have a pivot and the data source is always going to be dynamic; the row numbers can always change with each run.
I tried to create a table name with the data source and reference this table name and refresh the pivot. But this works only after I start creating the pivot and then add new rows of data.
In my case, my data source is always different from the beginning (varying number of rows), so I want it to automatically pick up the number of rows before I create the pivot.
Any suggestions?