+ Reply to Thread
Results 1 to 19 of 19

List of Parts for Kits

  1. #1
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    List of Parts for Kits

    Hello,

    On the BULLETIN# & KIT# sheet I would like to enter the kit in cell B4 and have the list of parts and their descriptions for that kit. Is this possible to do?

    Thank you very much for your help

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Hi,

    Please try this file

    Put your BULLETIN# & KIT# in Cell B4 and click on the Blue Box below it

    Note: I have renamed the Sheet name by just removing #

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Thank you so much that is amazing! My next task is to incorporate the other sheet into this one. Any ideas please? Or should I start another thread?

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Hi,

    I was just going through the sheet, let me bring to your notice that, the code only takes into consideration Columns G, H & I. I am not sure if you need the code to consider columns J - X.

    If yes please let me know what exactly needs to be done

  5. #5
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Oh yes I do and in fact I need to add more columns for the other sheet.

  6. #6
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Please guide me what the code exactly needs to look for?

  7. #7
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Not looking for but I just need to move the data from the other sheet first then utilize your code to allow for the extra columns of data.

  8. #8
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    I am kind of getting an idea, however, can you be a bit more specific with your requirement as I am still unable to completely contemplate what you expect the code to do.

    I am understanding there are 2 separate requirements -

    1) Move the data from the other sheet - I need more details on this
    2) Allow for the extra columns of data. Currently based on the BULLETIN# & KIT# thats mentioned in Cell B4, my code scans through the I column and gets the corresponding values in Col G & I. You want me to scan through all the columns from BULLETIN# & KIT#1 - BULLETIN# & KIT#16 and get the corresponding values in Col G & I and paste it one below other in the table8 on Column D & E. Is my understanding correct?

  9. #9
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    I will return soon. Thanks for your help.

  10. #10
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    You are welcome

  11. #11
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    The results from the code are not accurate. Can you take a look please
    Last edited by BobBrown60; 03-11-2021 at 08:41 PM.

  12. #12
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Hi,

    The result from my Code are accurate, although it only picks up from the I Column. That's what I have been saying in the past few posts and #8 has asked for clarification

  13. #13
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Yes 2 requirements. I need to move the data from the other sheet but not sure how. There are parts listed with descriptions and the third column has the bulletin and kit numbers. These need to move to the sheet so there will be more than 16 columns to search for there. I hope you can help thanks.
    Last edited by BobBrown60; 03-12-2021 at 04:28 AM.

  14. #14
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    HI,

    Please see the file attached. This should take care of picking parts from those additional columns.

    Can you confirm if the Parts & Description being returned is fine now?

    Also, I have named a couple of cells. Its always a good practice to do so while working with ranges is VBA.

    Note: I have assumed all the Column names will be BULLETIN & KIT #1, only the number after the # will change

    VBA Code for reference -

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by NeedForExcel; 03-12-2021 at 04:54 AM.

  15. #15
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Yes it seems to be accurate for the parts thank you. That takes care of one of the requirements. The next is to move the data from the other sheet please. I made some editing to highlight the cells that equal B4 to check all that apply.
    Last edited by BobBrown60; 03-12-2021 at 05:30 AM.

  16. #16
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Hi,

    Glad the file worked for you.

    Regarding the 2nd requirement, please explain me the logic how the data needs to be moved. What data should go where and all the things.. If you can explain me the requirement properly in depth, then it will be easier for me to code..

  17. #17
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    On the sheet that has the long 3 columns of data the 3rd column has the bulletin and kit numbers that when grouped will have the list of parts with their descriptions next to them. So in order to move the data to the other sheet the new bulletin and kit number will be added on the row for each part number. So there will be added columns to allow for these additions.

    I hope I have explain the proper details.

    Thank you very much for your fantastic help.

  18. #18
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: List of Parts for Kits

    Maybe you have a solution on how to move the data.
    Last edited by BobBrown60; 03-13-2021 at 05:24 AM.

  19. #19
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: List of Parts for Kits

    Hi Bob, sorry for the late reply.

    Moving data from one sheet to another is a pretty easy VBA code, but even after you explanation I am unable to understand what exactly needs to be done.

    If you can maybe replicate only those 2 sheets in a sample file and demonstrate a Before and After sheet for me to understand what the code exactly needs to do, it will be really helpful.

+ 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. Creating Automotive parts kits.
    By wtwos in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-03-2018, 02:02 PM
  2. Replies: 6
    Last Post: 05-01-2016, 04:41 AM
  3. Remove Kit components when Kits are created
    By BowtieAccountant in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2014, 02:02 PM
  4. Replies: 1
    Last Post: 12-16-2013, 02:30 PM
  5. Scan parts OUT to Sheet1, parts IN to Sheet2 and list in Sheet3
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 11:40 AM
  6. generated parts list from list of assemblies
    By staticchanger in forum Excel General
    Replies: 1
    Last Post: 06-24-2012, 05:20 PM
  7. [SOLVED] Finding the value from the list parts and insert extra part in the list
    By PRADEEPB270 in forum Excel General
    Replies: 3
    Last Post: 10-15-2010, 01:29 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