Hi,
I'm trying to create a report using a pivot table that crosses multiple sheets. I am new at pivot tables and would appreciate any help.
First tab "Mike's Crew" has the following information
<tbody>
</tbody>
Second Tab "Joe's Crew" has the following information
<tbody>
</tbody>
The final report that I would like to create using a pivot table, would combined the two sheets together and create a report that i could use to see the prices for all projects "Matt House" and "Joe's Patio" per month. As you can see each contractor have their own sheet and i want a report that has both f them combined. Also any project can be worked on by multiple contractors as seen with "Matt House"
Thanks,
I'm trying to create a report using a pivot table that crosses multiple sheets. I am new at pivot tables and would appreciate any help.
First tab "Mike's Crew" has the following information
Project | Type | Cost Center | January | Feb | March |
Matt House | New Home | 7500 | 21000 | 2250 | |
Matt House | New Home | Foundation | 1000 | 10000 | |
Matt House | New Home | Roof | 2000 | 3000 | 500 |
Matt House | New Home | Windows | 500 | 5000 | 750 |
Matt House | New Home | Labor | 4000 | 3000 | 1000 |
<tbody>
</tbody>
Second Tab "Joe's Crew" has the following information
Project | Type | Cost Center | January | Feb | March |
Joe's Patio | Patio Repair | 1900 | 5650 | 300 | |
Joe's Patio | Patio Repair | Wood Material | 1000 | 3000 | |
Joe's Patio | Patio Repair | Nails/Screws | 150 | 150 | |
Joe's Patio | Patio Repair | Labor | 750 | 2500 | 300 |
Matt House | New Home | 27000 | 18000 | 11000 | |
Matt House | New Home | Wood Material | 15000 | 5000 | |
Matt House | New Home | Roof | 2500 | 2500 | 2500 |
Matt House | New Home | Windows | 7500 | 7500 | 7500 |
Matt House | New Home | Labor | 2000 | 3000 | 1000 |
<tbody>
</tbody>
The final report that I would like to create using a pivot table, would combined the two sheets together and create a report that i could use to see the prices for all projects "Matt House" and "Joe's Patio" per month. As you can see each contractor have their own sheet and i want a report that has both f them combined. Also any project can be worked on by multiple contractors as seen with "Matt House"
Thanks,
Last edited: