Data quantity calculations & summary across multiple tabs

jonesy4000

New Member
Joined
Jun 6, 2019
Messages
6
I have a workbook for budgeting construction projects. Each element of a project gets its own tab (for example, walls, roof, floor, etc.). Within each of those tabs the user chooses a category of material from a drop down menu, then the actual material from a second drop down menu. Those drop downs reference a sheet with tables for each category. So, for example, tab "1" would be for the roof. In the first column they could choose "Lumber" which allows them in the second column to choose "2x8x8' #2 YP." Then, they manually input quantities of the material. And so it goes until all the necessary materials for each element are accounted for. Then, the process is repeated on the next tab for the next element.

Obviously, many materials are repeated in multiple tabs. For quick ordering purposes, I'd like to create a "Material Summary" tab that looks at all the element tabs, lists the materials chosen, and creates a sum of those materials from across all the tabs. There are hundreds of possible materials to choose from in the page of material tables, so the summary should only list materials that are actually chosen, and not a list of all possible materials. IDEALLY, it would group the materials by category, but that's not totally necessary.

I'm at a total loss for how to do this. Any help is appreciated.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,128,122
Messages
5,628,824
Members
416,342
Latest member
BlueDevil12

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