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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

alansidman

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

Watch MrExcel Video

Forum statistics

Threads
1,123,456
Messages
5,601,772
Members
414,472
Latest member
Chris_1990

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