Announcement

Collapse
No announcement yet.

convert Master Bill of materials into parent-child relations

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • convert Master Bill of materials into parent-child relations



    Hi all,

    Can someone help me to convert master BOM into Parent-Child relation from left to right as shown in the example file. Your VBA code help will be of great use to me to complete my task. Thanks.

    Attached Files

  • #2
    I am looking somebody to help with VBA code

    Comment


    • #3
      CROSS POST



      This question has been posted in at least one other forum.

      Do not post any further responses in this thread until a link has been provided to these cross posts.



      Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why.



      This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. Itís never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.

      Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
      Ali

      Enthusiastic self-taught user of MS Excel who's always learning!
      If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

      Comment


      • #4
        IMO, there's not enough information to attempt an answer.
        Hope that Helps

        Roy

        New users should read the Forum Rules before posting

        For free Excel tools & articles visit my web site

        RoyUK's Web Site

        royUK's Database Form

        Where to paste code from the Forum

        About me.

        Comment


        • #5
          HI royUK

          It is a multi-level bill of material, to make item on the left column we need right column bill of material and so on..
          to make cycle-0 i need M-002 which in turn require
          M-002-AAA
          and
          M-002-AAB which require
          M-002AAB-ZZ

          Hope i could explain to u


          thanks

          Comment


          • #6
            You need to post the links to the other sites out of courtesy. Also, you will find most Excel Forums require this.
            Hope that Helps

            Roy

            New users should read the Forum Rules before posting

            For free Excel tools & articles visit my web site

            RoyUK's Web Site

            royUK's Database Form

            Where to paste code from the Forum

            About me.

            Comment


            • #7
              My cross posting link is here. I am sorry for cross posting as i was not getting any help from my valuable helpful volunteers from here.

              https://www.excelforum.com/excel-pro...ls-format.html

              I am sorry about that

              Comment


              • #8


                You've also posted a almost identical question in our Forum.
                Hope that Helps

                Roy

                New users should read the Forum Rules before posting

                For free Excel tools & articles visit my web site

                RoyUK's Web Site

                royUK's Database Form

                Where to paste code from the Forum

                About me.

                Comment

                Working...
                X