+ Reply to Thread
Results 1 to 9 of 9

aaaaaa

Hybrid View

hejszyszki aaaaaa 05-07-2021, 05:54 AM
KOKOSEK Re: Complex Bill of Material 05-07-2021, 06:42 AM
hejszyszki Re: Complex Bill of Material 05-07-2021, 10:12 AM
KOKOSEK Re: Complex Bill of Material 05-07-2021, 10:27 AM
hejszyszki Re: Complex Bill of Material 05-07-2021, 10:38 AM
KOKOSEK Re: Complex Bill of Material 05-07-2021, 10:43 AM
hejszyszki Re: Complex Bill of Material 05-07-2021, 11:00 AM
hejszyszki Re: Complex Bill of Material 05-10-2021, 10:45 AM
hejszyszki Re: Complex Bill of Material 05-11-2021, 06:01 AM
  1. #1
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Complex Bill of Material

    Check yellow banner at the top of the page. Attach small sample file. It can be also helpful if you place expected result down there.

    < LANG pl=ON>Witam na forum< /LANG pl=OFF>
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  2. #2
    Registered User
    Join Date
    05-07-2021
    Location
    Warsaw
    MS-Off Ver
    MS365
    Posts
    20

    Re: Complex Bill of Material

    Hi kokosek,

    My bad not noticing the rules. There is a sample file.

    My idea is that user inputs Parent code & value in sheet PLAN. Then macro is looping through BOM page to find all components of parent material and output it to OutputSheet. Then a simple calculation that im able to do by myself.
    Just cant get through decomposing whole parent mat.

    Data exported to this file is in sheet BOM & output in sheet Output.

    Any ideas?

    Thanks in advance!
    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] Calculate Material Release - Bill of Material
    By mgoh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2021, 06:40 AM
  2. Copy down cells with SKU IDs in a Bill-of-Material
    By anasman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2017, 04:45 PM
  3. Multi level Bill of material
    By neorez in forum Excel General
    Replies: 36
    Last Post: 03-09-2016, 02:05 AM
  4. general bill of material
    By francesco.ciani88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2015, 02:04 PM
  5. [SOLVED] Bill of Material Data Look up issue
    By jacob@thepenpoint in forum Excel General
    Replies: 7
    Last Post: 05-07-2013, 11:06 AM
  6. 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
  7. bill of material, assemblies
    By jamesw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2011, 01:53 PM

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