Hi all,
When making a pivot table, i am required to input a range of cells in order for the table maker to obtain relevant information. However, as I am constantly inputting extra data, these ranges always need to be increased. The only solution i know to this problem is to creat a new pivot table each time the data in ym worksheet has increased.
Is it possible to have a pivot table so that it automatically increases the range of cells it works with? And if so, how is this done?
Regards,
Kongming
When making a pivot table, i am required to input a range of cells in order for the table maker to obtain relevant information. However, as I am constantly inputting extra data, these ranges always need to be increased. The only solution i know to this problem is to creat a new pivot table each time the data in ym worksheet has increased.
Is it possible to have a pivot table so that it automatically increases the range of cells it works with? And if so, how is this done?
Regards,
Kongming