+ Reply to Thread
Results 1 to 1 of 1

Expand BOM(bill of material) without Macro again

  1. #1
    Registered User
    Join Date
    06-29-2022
    Location
    china
    MS-Off Ver
    2010
    Posts
    14

    Cool Expand BOM(bill of material) without Macro again

    this is an enhanced version of my former work. in the old version it can only tackle trees like a family tree in which every node has only one parent node.
    but in single level BOM it's a common thing that there're some items with multiple parent nodes. this leads to increasing number of items in expanded result.
    so this new version tried to solve this problem. i used iterative calculation again rather than VBA macro. i admit VBA macro maybe a better solution, but iterative calculation solution is easy to use too. and this example is also a exploration for the potential of iterative calculation.

    Name:  EXPAND BOM.png
Views: 142
Size:  229.9 KB
    Attached Files Attached Files

+ 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. [SOLVED] aaaaaa
    By hejszyszki in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2021, 06:01 AM
  2. [SOLVED] Calculate Material Release - Bill of Material
    By mgoh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2021, 06:40 AM
  3. general bill of material
    By francesco.ciani88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2015, 02:04 PM
  4. Printing mutiple pdf's from a bill of material
    By joepjebaars in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2013, 02:16 PM
  5. Hide sheets in a Bill of Material
    By ajbele in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 06:13 PM
  6. bill of material, assemblies
    By jamesw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2011, 01:53 PM
  7. Multi level Bill of material
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2011, 04:35 AM

Tags for this Thread

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