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.

"Luke Bailey" wrote:

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?