Combining Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a workbook that has 3 pages representing data from 3 US
Regions: Central, Western, and Eastern. Each page has a named range for the
data: data_Central, data_Western, & data_Eastern). I would like to pivot the
data, but I need the pages combined. Is there a way to define or name the
range that is a Union of the 3 pages?
 
Look at the option in the creation of the pivot table to use Multiple
Consolidation Ranges instead of simply a list or Database.
 
You must log in or register to reply here.

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

Set non-continuous PrintArea via Function / Name 0
a data validation list that contains a list of named ranges - not alist from a named range 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel Need Countifs Formula Help 0
Excel VBA - Problem with Closing Print Preview 0
Using range names in functions 2
Named Ranges 2
Combine Pivot tables - confused about 'how-to' 7

Back
Top