How to auto adjust range of data source for pivot table in excel?




I am a reporting analyst and working on excel to perform most of my task. To summarize data, i frequently use Pivot table. One of the major problem with pivot, if there is any addition or deletion of records then i need to change the data source for same. I use multiple pivots for reporting and this process kills a lot of bandwidth. Can you suggest me a way that will automatically change the range of data source?



This can be solved by using dynamic range functionality in excel. We can create dynamic range using TABLE option and with the help of function like Indirect, Index and Offset.

For more detail on these function you can go through below link.