Hi!

Each month, I have to copy the sales report to a consolidated report, and the number of rows of data for each month is different. On the consolidated worksheet, there is a pivot table at the bottom of the page. So I am wondering which formula should I use to make sure there's enough rows to contain the new data, and the old data can be deleted automatically. Also, the pivot table can calculate the data with the new range.

For right now, i have to manually check the rows to make sure the new data don't cover the place where the pivot table is, and also change the source of the pivot table every time to make sure the calculation is correct. Thank you!