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)
Sheet2 (AdminExpense) (This will list all the expenses of the project related to the admin)
Sheet 3 (Construction Expenses) (This will list all of the construction Costs related to the project)
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 Name Start Date Project Manager 20200101V231 Jan 1, 2020 John Smith 202003V231 March 1, 2020 Mike Smith
Sheet2 (AdminExpense) (This will list all the expenses of the project related to the admin)
Rich (BB code):
ProjectName Expense Type Value Contract Number Billable 20200101V231 Legal $234.00 A-11-2133 Yes 20200101V231 Legal $15,332 A-22-341 No 20200101V231 Office Supply $134 No 202003V231 Communication $5675 A-34-212 Yes 202003V231 Admin Support $15,234 No
Sheet 3 (Construction Expenses) (This will list all of the construction Costs related to the project)
Rich (BB code):
ProjectName Product Type Cost Taxes Value (sum Cost+Taxes) Supplier 20200101V231 Lumber $100 $10 $110 Home Depot 20200101V231 Landscaping $2,000 $0 $2000 Mike's landscaping 20200101V231 Rental $150 $3.00 $153 Jane's Rentals 202003V231 Plumming $23,122 $10,000 $33,122 Home Depot