View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke Bailey
 
Posts: n/a
Default Combining Ranges

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?