Pivot table question
Posted on 2011-02-23
I have a workbook that has two worksheets. One is labeled 'Pivot' and the other is labeled 'raw data'. Pretty basic, the pivot table pulls the raw data.
What I would like to know if there is a way for me to use this over and over again (and have others use it as well) WITHOUT having to modify the range of the data each and every time the raw data is updated.
In other words, we use this every couple of weeks, or maybe once a month. Basically we blow the data out that is on the raw data tab and paste new data, which is formatted exactly the same, into it's place. However, the row count may vary. thus we have to adjust the range every time.
Is there not a way that we can paste new data and refresh the pivot table without having to adjust the range each tiime? Thanks.