Pvt Table Question

  • Thread starter Thread starter lj
  • Start date Start date
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!
 
Alt/DP, then choose Multiple consolidation ranges -- the UI was removed from
the ribbon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pvt Table Question 1
Sorting Options for Pvt Tables 3
Pivot tables downgrade 2007->2003 3
pivot tables that combine several data tabs 2
GetPivotData Function 5
Access VBA to manipulate an Excel spreadsheet 2
Merge and Centre 3
how to activate a cell if it contains data 1

Back
Top