Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

  1. #11
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,074
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    Ok, let's say your data in sheet Part is this:

    Excel 2013/2016
    ABC
    1PART_IDMISC_REFERENCEORDER_QTY
    2S81001BURNER, RPLMNT LEX485/605/730,LE,LD4854
    3S81001BURNER, RPLMNT LEX485/605/730,LE,LD4851
    4S81001BURNER, RPLMNT LEX485/605/730,LE,LD4853
    5S81004BURNER, IR SIDE ROGUE 365/425/525/6251
    6S81004BURNER, IR SIDE ROGUE 365/425/525/6251
    7S83007GRIDS, SS 525 SERIES1
    8S83007GRIDS, SS 525 SERIES1

    Parts





    Can you show us what result should look like?

  2. #12
    New Member
    Join Date
    Apr 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    PART_ID MISC_REFERENCE ORDER_QTY
    S82001 CASTER, (2) P500/PRO500/ROGUE 4 gets changed to
    N100-0044 =1 * 4 new row
    N305-0082 = 2 *4 new row
    N570-0068 = 1 * 4 new row
    N510-0015 SOCKET, CASTER 365/425/525 4
    S88005 KNOB, LG ROGUE/P500 2
    N380-0021-CL = 1 * 2 new row

    I updated the drop box too https://www.dropbox.com/s/9xrzngza8k...Kits.xlsm?dl=0

  3. #13
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,074
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    No, I mean let's say the data is only as I posted above.
    What the result should look like? don't use any explanation in the result, just the result.

  4. #14
    New Member
    Join Date
    Apr 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    A B C A B C
    1 PART_ID MISC_REFERENCE ORDER_QTY PART_ID MISC_REFERENCE ORDER_QTY
    2 S81001 BURNER, RPLMNT LEX485/605/730,LE,LD485 4 1 N100-0036 xxx 4
    3 S81001 BURNER, RPLMNT LEX485/605/730,LE,LD485 1 2 N305-0057-M01 xxxx 4
    4 S81001 BURNER, RPLMNT LEX485/605/730,LE,LD485 3 3 N570-0008 xxx 4
    5 S81004 BURNER, IR SIDE ROGUE 365/425/525/625 1 4 N100-0036 xxx 1
    6 S81004 BURNER, IR SIDE ROGUE 365/425/525/625 1 5 N305-0057-M01 xxxx 1
    7 S83007 GRIDS, SS 525 SERIES 1 6 N570-0008 xxx 1
    8 S83007 GRIDS, SS 525 SERIES 1 7 N100-0036 xxx 3
    8 N305-0057-M01 xxxx 3
    9 N570-0008 xxx 3
    10 N100-0053 xxx 1
    11 N100-0053 xxx 1
    12 N305-0101 xxx 1
    13 N305-0099 xxx 2
    14 N305-0101 xxx 1
    15 N305-0099 xxx 2

  5. #15
    New Member
    Join Date
    Apr 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    you bet, i put it in the drop box too

  6. #16
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,074
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    What do you mean?
    Your last sample file do not show the result of the example I posted.

  7. #17
    New Member
    Join Date
    Apr 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    A B C
    PART_ID MISC_REFERENCE ORDER_QTY
    1 N100-0036 xxx 4
    2 N305-0057-M01 xxxx 4
    3 N570-0008 xxx 4
    4 N100-0036 xxx 1
    5 N305-0057-M01 xxxx 1
    6 N570-0008 xxx 1
    7 N100-0036 xxx 3
    8 N305-0057-M01 xxxx 3
    9 N570-0008 xxx 3
    10 N100-0053 xxx 1
    11 N100-0053 xxx 1
    12 N305-0101 xxx 1
    13 N305-0099 xxx 2
    14 N305-0101 xxx 1
    15 N305-0099 xxx 2

  8. #18
    New Member
    Join Date
    Apr 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    sorry i just uploaded it, the tab example.

  9. #19
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,074
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    Ok, I think I got it.
    I'll get back to you tomorrow.
    It's past midnight in my time zone.

  10. #20
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,074
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    Why column MISC_REFERENCE become 'xxx'?
    Does it become blank or stay the same?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •