Combining worksheets/tables into one consolidated table (or pivot

G

genxgeek

Greetings!

I would very much appreciate any information on the following ASKs. Thanks
in advance!

ASKs
-How to create a pivot table from mutiple tables (multiple sheets within the
same work book).
-How to grab the label contents of a tab (within a pivot table)

I'm trying to avoid all of this programatically (macro) but if that is what
it takes then I can write some VB.

I tried using the multiple consolidated pivot view but it's quite crude and
makes no sense to me.

I'm just looking for something like:

Worksheet1:
OrderNo Qty
1 10
2 1

Worksheet2:
OrderNo Qty
3 5
4 2

Cosolidated view (Table or Pivot Table):
OrderNo Qty
1 10
2 1
3 5
4 2


Thanks!
 

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

Countifs or a pivot 1
Calculate a pivot table that has consolidated multiple worksheets 0
Pivot Table/Conditional Formatting Guru Help 2
Pivot Table counting a range 1
Multiple Range Pivot Table (Urgent Please) 0
Pivot Table Set Up 2
Rank items in Pivot Table 3
Pivot Table Question 1

Top