Pivot Table over multiple sheets (PowerPivot?)

snake

New Member
Joined
Jan 7, 2020
Messages
3
Hi there, I have a three sheet worksheet where they are all related with a projectname but I want to be able to create one pivot table to report on. Each of the sheets will always have the project name for which the expense was related too, but each of the sheet have a different order to them and additional fields. Currently, I just copy sections from each sheet into a new sheet and pivot table that but I want to know if there is an easier way (its just cumbersome to do each week)


Here are what the tables look like:

Sheet 1 (ProjectList): (this is the major table that will list all of the projects and project managers - project name will always be unique here)

Rich (BB code):
Project NameStart DateProject Manager
20200101V231Jan 1, 2020John Smith
202003V231March 1, 2020Mike Smith

Sheet2 (AdminExpense) (This will list all the expenses of the project related to the admin)

Rich (BB code):
ProjectNameExpense TypeValueContract NumberBillable
20200101V231Legal$234.00A-11-2133Yes
20200101V231Legal$15,332A-22-341No
20200101V231Office Supply$134No
202003V231Communication$5675A-34-212Yes
202003V231Admin Support$15,234No

Sheet 3 (Construction Expenses) (This will list all of the construction Costs related to the project)
Rich (BB code):
ProjectNameProduct TypeCostTaxesValue (sum Cost+Taxes)Supplier
20200101V231Lumber$100$10$110Home Depot
20200101V231Landscaping$2,000$0$2000Mike's landscaping
20200101V231Rental$150$3.00$153Jane's Rentals
202003V231Plumming$23,122$10,000$33,122Home Depot
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,060
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
deleted Not right solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,314
Messages
5,595,441
Members
413,991
Latest member
waterstone

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top