How to resize range used by pivot table?
Posted on 2014-03-24
Hello - I've got a pivot table that is based on a range of data built up on one tab from a series of copy/paste operations from another tab. The final range will be larger (more rows) every time the operation is run.
How can I resize the range in the pivot table data source after the copy/paste's?