Hi,

That is not what the multiple consolidation command is all about
unfortunately. You need to either put all the data into one data area, or
use a complex pivot table operation call UNION query.

--
Thanks,
Shane Devenshire


"terri" wrote:

I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs a

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.