+ Reply to Thread
Results 1 to 10 of 10

Bill of Materials conversion from multi level to single level

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Bill of Materials conversion from multi level to single level

    Book1.xlsx

    Dear Experts,

    I am herewith attaching a file that contains the problem.
    I have multi level BOM available as a input & I want it to convert into single level.

    Please help me...

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Bill of Materials conversion from multi level to single level

    I don't understand what you're trying to do. Are you adding values to get this output?
    <--- If you like the answer, press *.

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    UK
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    86

    Re: Bill of Materials conversion from multi level to single level

    Personally I think I would go with a VBA solution for this one.
    Is that an option?

  4. #4
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Smile Re: Bill of Materials conversion from multi level to single level

    Quote Originally Posted by zumbalj View Post
    I don't understand what you're trying to do. Are you adding values to get this output?
    Thanks for your reply...
    I am receiveing this input from our CAD data & I want to upload this data in ERP but the ERP needs this data in single level.
    Hence I want to modify the available input in prescribed output format...

    Moreover I don't know VBA, I know only excel...

    Thanks...

  5. #5
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Bill of Materials conversion from multi level to single level

    Thanks for your reply...

    I don't know VBA, I know only excel...

    Thanks...

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Bill of Materials conversion from multi level to single level

    Yeah but if they gave you a VBA solution would that work?

  7. #7
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Bill of Materials conversion from multi level to single level

    Book1.xlsxI would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

    Then the formulas I have on the right work fine for what you are trying to do.

  8. #8
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Bill of Materials conversion from multi level to single level

    Quote Originally Posted by mikeTRON View Post
    Attachment 248797I would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

    Then the formulas I have on the right work fine for what you are trying to do.
    Thank you very much for sparing your time for my problem....
    Aboe given formula works for the sheet i have uploaded earlier.
    But there are few cases where this formula is not working.
    I have uploaded a case where it won't work.

    Moreover i am facing trouble in copying the up one cell data. Upto identifying blanks in entire database is OK but after that what i have to do? Can you elaborate in detailed steps???

  9. #9
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Bill of Materials conversion from multi level to single level

    Book3.xlsx
    Quote Originally Posted by mikeTRON View Post
    Attachment 248797I would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

    Then the formulas I have on the right work fine for what you are trying to do.
    Thank you very much for sparing your time for my problem....
    Aboe given formula works for the sheet i have uploaded earlier.
    But there are few cases where this formula is not working.
    I have uploaded a case where it won't work.

    Moreover i am facing trouble in copying the up one cell data. Upto identifying blanks in entire database is OK but after that what i have to do? Can you elaborate in detailed steps???

  10. #10
    Registered User
    Join Date
    07-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Bill of Materials conversion from multi level to single level

    Hello mikeTRON

    Can you help me?

    With thanks.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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