Author: Shane DevenshireShane Devenshire Date: Jan 28, 2010 21:34
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.
> .
>
| 
