I've googled and searched but I'm not sure if I'm using the right words....
I created a pivot table using 10 worksheets in a workbook (one for each month). I've just added November's data into the worksheet and now I need to add November to the Pivot Table but I can't seem to figure out how to do it without re-doing the whole table.
I tried to go back into the wizard and add the range to the ranges list, but then it said you cannot overlap pivot tables....
How can I do this?
Bookmarks