To generalise this I'd first set up a dynamic range name which will automatocally adjust to the size of your data.
So create a name say "Data" and defne it as
Now click in the PT, go to the Pivot Table Tools menu and click the Change Data Source item. Where yiuo currently see A1:D42 enter instead the word Data. Then OK.
I'd be onclined to move the PT to a sheet of its own
If the data changes you'll need to right click in the PT and choose Refresh. You can aitomate this with a VBA sheet activate macro in the sheet that contains the PT.
so that every time you go
Bookmarks