Pivot Table from two worksheets

  • Thread starter Thread starter msherman83
  • Start date Start date
M

msherman83

I am trying to create a pivot table from two worksheets. Each workshee
represents different accounts from which I am tracking expenses. I hav
these columns on both sheets: Type of Expense (labeled A, B, C, D)
Date, Description, and Amount.

I want the pivot table to organize all of the data from both sheet
according to Type of Expense and show the Date, Description, and Amoun
under each Type of Expense. I can get it to organize it by Type o
Expense and show a total for each, but how do I get it to show thi
additional information?

Thanks
 
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single range.

If possible, move your data to a single worksheet, or store it in a
database, such as MS Access, and you'll have more flexibility in
creating the pivot table.
 
Back
Top