Excel Question

[MadBadger]

So I reached the maximum number of rows for a worksheet I'm doing, and Ive started doing more on a different worksheet. My question is that I already have a pivot table linked to the original data. Is there a way to use to existing pivot table and have it link to both worksheets? Hopefully without creating a new one.

[unhappycamper]

1. Nope.

The source data for a pivot table can come from only one data source.

About the only way to do this is to create a pivot table for the first data set, create another pivot table for the second data set, and (you're going to hate this) manually compile the results between the two pivot tables.

You could probably write something fairly easily in Perl to give you results in a single, automated pass.