Hello,
I currently use find and replace in my macro, but I am needing to replace one kit# with the two components. The second item would be 2x the qty of the original kit qty.
Id need to replace "bracket-kit" with "bracket," and add a second line for "bolts." The bracket line can simply replace the kit part#, and keep whatever qty was in column B. I usually have another line with "bolts," but not always. Ideally, this would add the bolts qty to an existing row if it exists, or create a new row and insert "bolts."
Below is an example of my setup. The description in column C uses vlookup, and column A is automatic. Only columns B and D are relevant.
qty is in column B, and part# is in column D.
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
any help would be greatly appreciated.
Thanks
I currently use find and replace in my macro, but I am needing to replace one kit# with the two components. The second item would be 2x the qty of the original kit qty.
Id need to replace "bracket-kit" with "bracket," and add a second line for "bolts." The bracket line can simply replace the kit part#, and keep whatever qty was in column B. I usually have another line with "bolts," but not always. Ideally, this would add the bolts qty to an existing row if it exists, or create a new row and insert "bolts."
Below is an example of my setup. The description in column C uses vlookup, and column A is automatic. Only columns B and D are relevant.
qty is in column B, and part# is in column D.
ITEM NO. | QTY. | Description | Part Number |
1 | 1 | 2in bracket with hardware | bracket kit |
2 | 1 | angle bracket | 2in bracket |
3 | 2 | bolt and nut | bolts |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
any help would be greatly appreciated.
Thanks