advanced find and replace [split one row into 2 rows]

[solidENM]

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.

[TABLE="width: 376"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]ITEM NO.[/TD]
[TD]QTY.[/TD]
[TD]Description[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]2in bracket with hardware[/TD]
[TD]bracket kit[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]angle bracket[/TD]
[TD]2in bracket[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]bolt and nut[/TD]
[TD]bolts[/TD]
[/TR]
</tbody>[/TABLE]



any help would be greatly appreciated.
Thanks