View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default PivotTable based on multiple ranges or tables

Step 1 of the pivot table creation wizard has 3 different options for source
data. The third option is Multilple Consolidation Ranges whixh will allow you
to consolidate from multiple sheets. You may want to add the Office number
inot the source ranges on each sheet so that your pivot table can consolidate
by office.
--
HTH...

Jim Thomlinson


"Candace" wrote:

If I have multiple ranges or tables on one worksheet, can I create a Pivot
Table based off of more than one range or table? For example, if a worksheet
has the following tables/ranges: office1, office2, office3, and each
table/range contains a list of equipment for each of those offices, can I use
create a PivotTable that shows the "telephone" equipment from all three
offices?