Pvt Table Question

L

lj

Hi,
I'm in excel 2007. I have a couple of really big sheets and would
like to make a pvt table. My question is - is it possible to make a
pvt table using two sheets? If so, how do you do this? Thanks!
 
B

Bob Umlas

Alt/DP, then choose Multiple consolidation ranges -- the UI was removed from
the ribbon.
 
Top