I'm using Excel 2007, and the data is in one workbook but two
different worksheets. Other than using a Microsoft Query, it sounds
like the only way to do it is to combine the data into a single sheet
as suggested. Thanks.

On Jan 28, 3:34*pm, Shane Devenshire
wrote:
Depends on the version of Excel - I per chance you are using 2010, yes I said
that, you can use PowerPivot to do it.

In 2007 and earlier you can use Microsoft Query and write a union query, but
you really need to know what you are doing.

The easiest way is to do as previously suggested - combine the data into a
singe range and pivot that. *

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire



"Shig" wrote:
I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.
.