+ Reply to Thread
Results 1 to 6 of 6

Calculating & summarizing total quantities of multiple materials across multiple tabs.

  1. #1
    Registered User
    Join Date
    06-06-2019
    Location
    Cincinnati, OH
    MS-Off Ver
    XP
    Posts
    6

    Calculating & summarizing total quantities of multiple materials across multiple tabs.

    This post was originally a response to a prior thread, but I have created a new thread. I haven't posted enough to allow links, yet, but for reference the original is called "Data sorting and calculations"

    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. I've attached the document. The relevant tabs are the numbered ones in the middle. I also created a "Material Summary" tab as a starting point for where this info should go.

    Thanks a lot!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: Calculating & summarizing total quantities of multiple materials across multiple tabs.

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. I will provide the link for you as upi are new here.)

    https://www.mrexcel.com/forum/excel-...iple-tabs.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-06-2019
    Location
    Cincinnati, OH
    MS-Off Ver
    XP
    Posts
    6

    Re: Calculating & summarizing total quantities of multiple materials across multiple tabs.

    Thanks you very much. I apologize for that. I didn't catch the regulation, but I completely understand why it exits.

    This query is also posted at Mr Excel. See above post for link.

  4. #4
    Registered User
    Join Date
    06-06-2019
    Location
    Cincinnati, OH
    MS-Off Ver
    XP
    Posts
    6

    Re: Calculating & summarizing total quantities of multiple materials across multiple tabs.

    This question has been answered in a different forum. Thanks a lot.

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Calculating & summarizing total quantities of multiple materials across multiple tabs.

    Welcome to the forum.

    One more thing: go to the top of this post, select thread tools and mark as solved .
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  6. #6
    Registered User
    Join Date
    06-06-2019
    Location
    Cincinnati, OH
    MS-Off Ver
    XP
    Posts
    6

    Re: Calculating & summarizing total quantities of multiple materials across multiple tabs.

    That's where that is! Thanks. Done.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 09-13-2017, 02:08 PM
  2. Multiple drop down list total over multiple tabs
    By steveosh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-08-2017, 01:33 PM
  3. How to: If cell L2 in multiple tabs = 1, then add that 1 to a total
    By lauralippay in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-13-2015, 11:31 PM
  4. Replies: 2
    Last Post: 05-07-2014, 01:12 PM
  5. Working with tabs and calculating across multiple ones
    By cgsweger in forum Excel General
    Replies: 1
    Last Post: 01-06-2014, 03:19 PM
  6. Finding total quantities in multiple lines of data
    By robbo46 in forum Excel General
    Replies: 1
    Last Post: 01-06-2012, 12:13 PM
  7. Calculating totals for items with associated quantities over multiple rows
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2009, 01:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1