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

[cmeredith1973]

Hi - first time caller, long time listener.

In my world, I have a long list of parts. What I want to do, is create a macro, that will when run, ask me what part # are you looking for.
When found, it looks up the part and inserts the necessary # of rows.

What I have is service kits that are made up of part numbers. The service kits are intermixed with a list of part numbers. So each time a service kit is searched and found, xl will add the necessary part numbers that make up that service kit to explode the parts found within the kit. This will give me a true count of the parts ordered and found.

example
Parts Col.
S81001 is made up of 3 part numbers. When the xl finds the S81001 it adds 3 rows below it. If the xl finds a smaller service kits, it adds 2 rows.
thank you in advance

 

[Akuini]

Could you post a sample data as table?
To copy a simple table from worksheet:
1. In your worksheet select the table/range
2. In the menu, select border icon > select All Borders > then copy.
3. Back to the thread > in the reply box paste the table

 

[cmeredith1973]

<colgroup><col style="mso-width-source:userset;mso-width-alt:6692;width:137pt" width="183"> <col style="mso-width-source:userset;mso-width-alt:13933;width:286pt" width="381"> <col style="mso-width-source:userset;mso-width-alt:5083;width:104pt" width="139"> </colgroup><tbody>
[TD="class: xl73, width: 183"]PART_ID[/TD]
[TD="class: xl73, width: 381"]MISC_REFERENCE[/TD]
[TD="class: xl73, width: 139"]ORDER_QTY[/TD]

[TD="class: xl73"]N335-0098-M06[/TD]
[TD="class: xl73"]NGZ LID,IR SD MIR/LE/500/450/600[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N335-0048-M02[/TD]
[TD="class: xl73"]!!! **** NGZ LID, IR SD BRN MC485/PRO'S[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]PROTOTYPE-HEARTH[/TD]
[TD="class: xl73"]PROTOTYPE-NEFL50QH[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]PROTOTYPE-HEARTH[/TD]
[TD="class: xl73"]PROTOTYPE-NEFL42QH[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N750-0040[/TD]
[TD="class: xl73"]WIRE, REAR/SIDE BURNER 45" LEAD PRO[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N750-0034[/TD]
[TD="class: xl73"]WIRE, JUMPER CONN IGNITER BIPRO665/825[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N707-0012[/TD]
[TD="class: xl73"]TRANS LIGHTS PRO500-1/665-1/825-1 N.A.[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N660-0009[/TD]
[TD="class: xl73"]SWITCH, MOMNTRY 4.5VDC PRO500/665/825-3[/TD]
[TD="class: xl73, align: right"]2[/TD]

[TD="class: xl73"]N357-0022[/TD]
[TD="class: xl73"]IGNITER, BLOCK 4 SPARK 12VAC/DC PRO -3[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N190-0005-T[/TD]
[TD="class: xl73"]* CONTROL, MAIN PRO500/665/825-3 TESTED[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]17222000009469[/TD]
[TD="class: xl73"]ELECTRONIC CTRL BOX ASSY (NH21-12F-I)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]W357-0016-SER[/TD]
[TD="class: xl73"]IGNITOR, HOT SURFACE 120V NITRIDE (GF)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N120-0007G[/TD]
[TD="class: xl73"]**** CAP,SDSHLF RGHT GRY450/500/600/750[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N120-0006G[/TD]
[TD="class: xl73"]**** CAP, SDSHLF LFT GRY 450/500/600/750[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]S82001[/TD]
[TD="class: xl73"]CASTER, (2) P500/PRO500/ROGUE[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]S88008[/TD]
[TD="class: xl73"]KNOB, SM P SERIES.[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N105-0003[/TD]
[TD="class: xl73"]!!! STOP BUSHING, HEAVY DUTY ROTIS KIT [/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]W565-0242-SER[/TD]
[TD="class: xl73"]SCREEN, PREMIUM SAFETY (GX36-1)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]17123000000402[/TD]
[TD="class: xl73"]MAIN CONTROL BOX ASSY (WVA)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]W010-2612[/TD]
[TD="class: xl73"]*CONTROL, INTEGRATED SS ENDURA PRO (GF)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]W010-2609[/TD]
[TD="class: xl73"]* EXHAUSTER, SINGLE SPD (GAS FURNACE)[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]GL-620[/TD]
[TD="class: xl73"]*LOG SET - GDS28/CDVS280[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N380-0033[/TD]
[TD="class: xl73"]*KNOB, PATIO FLAME TABLE KENS3[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N380-0032[/TD]
[TD="class: xl73"]NGZ KNOB CONTR ROUND SM BLUE GRIP[/TD]
[TD="class: xl73, align: right"]2[/TD]

[TD="class: xl73"]N380-0031[/TD]
[TD="class: xl73"]NGZ KNOB CONTR ROUND LRG BLUE GRIP[/TD]
[TD="class: xl73, align: right"]2[/TD]

[TD="class: xl73"]S82001[/TD]
[TD="class: xl73"]CASTER, (2) P500/PRO500/ROGUE[/TD]
[TD="class: xl73, align: right"]2[/TD]

[TD="class: xl73"]N680-0001-SER[/TD]
[TD="class: xl73"]THERMOCOUPLE PF450/600/GPFL48/GSS48[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]S86002[/TD]
[TD="class: xl73"]IGNITER, 1 SPARK [/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N750-0016[/TD]
[TD="class: xl73"]WIRE, 28" I.R. BURNER/SBRN LEAD MIR[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N240-0026[/TD]
[TD="class: xl73"]* ELECTRODE, IR SIDE BURN MIR[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]N010-1097[/TD]
[TD="class: xl73"]ASSY, LRG LED MULTI CLR CHNG PRO -3[/TD]
[TD="class: xl73, align: right"]1[/TD]

[TD="class: xl73"]S85001[/TD]
[TD="class: xl73"]REGULATOR 14" HOSE 1 OUTLET[/TD]
[TD="class: xl73, align: right"]1
[/TD]

</tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2377;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:5558;width:114pt" width="152"> </colgroup><tbody>
[TD="class: xl73, width: 111"]Model Number[/TD]
[TD="class: xl73, width: 65"]Quantity[/TD]
[TD="class: xl73, width: 152"]Original part number[/TD]

[TD="class: xl74"]S81001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N100-0036[/TD]

[TD="class: xl74"]S81001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N305-0057-M01[/TD]

[TD="class: xl74"]S81001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N570-0008[/TD]

[TD="class: xl75"]S81004[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N100-0053[/TD]

[TD="class: xl74"]S81005[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N010-0612[/TD]

[TD="class: xl75"]S81006[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N565-0002[/TD]

[TD="class: xl74"]S81007[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N010-0499[/TD]

[TD="class: xl75"]S82001[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N130-0010[/TD]

[TD="class: xl74"]S83001[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0058[/TD]

[TD="class: xl75"]S83002[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]Z305-0010[/TD]

[TD="class: xl74"]S83004[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]Z305-0003K[/TD]

[TD="class: xl75"]S83005[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0063[/TD]

[TD="class: xl74"]S83006[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0083-BK2FL[/TD]

[TD="class: xl75"]S83007[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N305-0101[/TD]

[TD="class: xl75"]S83007[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0099[/TD]

[TD="class: xl74"]S83008[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0097[/TD]

[TD="class: xl75"]S83009[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N305-0098[/TD]

[TD="class: xl74"]S83010[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N010-0763[/TD]

[TD="class: xl75"]S83011[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0084[/TD]

[TD="class: xl74"]S83012[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N305-0076[/TD]

[TD="class: xl75"]S83013[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0096[/TD]

[TD="class: xl74"]S83014[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0085[/TD]

[TD="class: xl75"]S83015[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0100[/TD]

[TD="class: xl74"]S83016[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0099[/TD]

[TD="class: xl75"]S83017[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N305-0100[/TD]

[TD="class: xl75"]S83017[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N305-0102[/TD]

[TD="class: xl74"]S84001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N010-0501-M01[/TD]

[TD="class: xl75"]S84002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N010-0512-M01[/TD]

[TD="class: xl74"]S84003[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N010-0521-M01[/TD]

[TD="class: xl75"]S84004[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N710-0093[/TD]

[TD="class: xl74"]S84005[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N710-0063[/TD]

[TD="class: xl75"]S84006[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]Z710-0001-M05[/TD]

[TD="class: xl74"]S84007[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]Z710-0002-M05[/TD]

[TD="class: xl75"]S84008[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]Z710-0003-M05[/TD]

[TD="class: xl74"]S85001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N530-0003[/TD]

[TD="class: xl75"]S85002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75, align: right"]66010[/TD]

[TD="class: xl74"]S85003[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N345-0014[/TD]

[TD="class: xl75"]S86002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N357-0013[/TD]

[TD="class: xl74"]S86003[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N357-0014[/TD]

[TD="class: xl75"]S86004[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N357-0015[/TD]

[TD="class: xl74"]S87001[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N305-0082[/TD]

[TD="class: xl74"]S87001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N100-0044[/TD]

[TD="class: xl74"]S87001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N570-0068[/TD]

[TD="class: xl75"]S87002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]Z100-0003[/TD]

[TD="class: xl75"]S87002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]Z305-0009[/TD]

[TD="class: xl75"]S87002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N570-0013[/TD]

[TD="class: xl74"]S87003[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]Z305-0010[/TD]

[TD="class: xl74"]S87003[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]Z305-0011[/TD]

[TD="class: xl75"]S87004[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]Z305-0003K[/TD]

[TD="class: xl75"]S87004[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]Z305-0005K[/TD]

[TD="class: xl74"]S87005[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]Z305-0010[/TD]

[TD="class: xl74"]S87005[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]Z305-0011[/TD]

[TD="class: xl75"]S87006[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N570-0008[/TD]

[TD="class: xl75"]S87006[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N080-0202-M01[/TD]

[TD="class: xl74"]S87007[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N570-0008[/TD]

[TD="class: xl74"]S87007[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N080-0208[/TD]

[TD="class: xl75"]S87008[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N570-0008[/TD]

[TD="class: xl75"]S87008[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N080-0209[/TD]

[TD="class: xl74"]S87009[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]Z570-0039[/TD]

[TD="class: xl74"]S87009[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N080-0281[/TD]

[TD="class: xl75"]S87010[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N570-0068[/TD]

[TD="class: xl75"]S87010[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N080-0423[/TD]

[TD="class: xl74"]S87011[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N570-0068[/TD]

[TD="class: xl74"]S87011[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N080-0406[/TD]

[TD="class: xl75"]S87012[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N308-0082[/TD]

[TD="class: xl75"]S87012[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N100-0057[/TD]

[TD="class: xl75"]S87012[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N570-0038[/TD]

[TD="class: xl74"]S87013[/TD]
[TD="class: xl74, align: right"]3[/TD]
[TD="class: xl74"]N080-0418[/TD]

[TD="class: xl74"]S87013[/TD]
[TD="class: xl74, align: right"]3[/TD]
[TD="class: xl74"]N570-0122[/TD]

[TD="class: xl75"]S87014[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N485-0026[/TD]

[TD="class: xl75"]S87014[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N485-0021[/TD]

[TD="class: xl74"]S87015[/TD]
[TD="class: xl74, align: right"]4[/TD]
[TD="class: xl74"]N450-0049[/TD]

[TD="class: xl74"]S87015[/TD]
[TD="class: xl74, align: right"]4[/TD]
[TD="class: xl74"]N570-0101[/TD]

[TD="class: xl74"]S87015[/TD]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl74"]N450-0050[/TD]

[TD="class: xl75"]S88001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N380-0021-CL[/TD]

[TD="class: xl74"]S88002[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N380-0020-CL[/TD]

[TD="class: xl75"]S88003[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N380-0024-CL[/TD]

[TD="class: xl74"]S88004[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N380-0025-CL[/TD]

[TD="class: xl75"]S88005[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N380-0021-CL[/TD]

[TD="class: xl74"]S88006[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N380-0020-RD[/TD]

[TD="class: xl75"]S88007[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N380-0029[/TD]

[TD="class: xl74"]S88008[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N380-0030[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]5[/TD]
[TD="class: xl75"]N570-0008[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N240-0025[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]2[/TD]
[TD="class: xl75"]N750-0016[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N357-0014[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N043-0002[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N240-0016[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N240-0001[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N240-0026[/TD]

[TD="class: xl75"]S89001[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N350-0054[/TD]

[TD="class: xl74"]S91001[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N685-0013-SER[/TD]

[TD="class: xl75"]S91002[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N685-0021[/TD]

[TD="class: xl74"]S91003[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N685-0004[/TD]

[TD="class: xl75"]S91004[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N685-0006[/TD]

[TD="class: xl74"]S91005[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N685-0004C[/TD]

[TD="class: xl75"]S91006[/TD]
[TD="class: xl75, align: right"]1[/TD]
[TD="class: xl75"]N685-0010[/TD]

[TD="class: xl74"]S91007[/TD]
[TD="class: xl74, align: right"]1[/TD]
[TD="class: xl74"]N685-0011[/TD]

</tbody>

 

[Akuini]

1. Those 2 tables, in what sheets are they located?

ask me what part # are you looking for

2. Using input box or what?

inserts the necessary # of rows.

3.Where do you want to insert the row?


It would be helpful if you could upload a sample workbook to a site such as dropbox.com then put the link here.
And then give an example in more detail what you're trying to do.

 

[cmeredith1973]

Hi the two tables are in an excel workbook that gets refreshed through a SQL query. Once updated, I get the updated results table of how many parts I've sent out. This is table 1. Table 2 is a static look up table that contains service kits. These kits get loaded as 1 part, but each month, I add up how many parts got sent out. The catch is that my part count is made up of the kits and regular parts, that have an un-exploded kit. If I count only kits, im not really accounting for the parts inside the kit.

What I was hoping to do, is create a macro with VB. In this, after I refresh the SQL, ideally, I'd launch the macro through a button, that will search out the kit # in table 1, one kit at a time, look up the kits part values in table 2. Then replace the kit line with the part line and add extra rows to account for the parts within the kit and quantities. Then I'd look up the 2nd kit and do the same thing. I have a lot of these kits and the dialgue box will get eventually fatiguing.

 

[Akuini]

Well, as I said, It would be helpful if you could upload a sample workbook to a site such as dropbox.com then put the link here.
It's hard to understand without seeing a sample workbook.

 

[cmeredith1973]

Hey can you see this link? https://napoleonproducts-my.sharepoint.com/:f:/g/personal/cmeredith_napoleon_com/EpPVzoZWRoBPl0_fnMYFJasB3-6tRTeJfRuamzcd8n7nOw?e=QesrAN

 

[cmeredith1973]

thank you for even looking at this!!

 

[Akuini]

Hey can you see this link?

I can't, the site wants me to sign in, I don't have an account in the site.

 

[cmeredith1973]

https://www.dropbox.com/s/9xrzngza8k8fv0a/Test EXCEL Parts & Kits.xlsm?dl=0