Inserting ROWS Challenge

[bfedorcha]

I would like to insert rows of data based on a particular match. The matching string would be stored in a range along with the rows to be inserted. The following example provides an idea of what I am trying to achieve. I would look for category name="Common Category" and insert the two attribute rows below the found object.



Before
category name="Common Category"
some value in this row
some value in this row



After
category name="Common Category"
attribute Name="Document Type">SOP
attribute Name="Document Sub-Type">NA
some value in this row
some value in this row



Where if the string is found the row(s) would be inserted below the matching string. The example shows two but it would be the defined range.



Matching String (stored at specific range)
ategory name="Common Category"
attribute Name="Document Type">SOP
attribute Name="Document Sub-Type">NA



Anyone have a solution?