Inserting Row(s) After Finding A Match

B

bfedorcha

Joined
Jun 28, 2007
Messages
3
Reaction score
0
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.


category name="Common Category"

attribute Name="Document Type">SOP</attribute

attribute Name="Document Sub-Type">NA</attribute


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.

Anyone have a solution?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting ROWS Challenge 0
Inserting Row(s) After Finding A Match 0
Help: Find Matching Cells, If - Then Move Cell With Self 2
Inserting a row below a combobox determined cell 1
Macro to insert Rows 4
End process at last row of data 3
Keeping formulas on an insert 1
Insert Row also adds formulas and moves cursor 2

Back
Top