Insert row if text doesn't exist

[murzyn1975]

Hi All,

I have an Excel sheet that looks like this:
A1
Section 1
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
Section 2
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
Section 3
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>

This goes on until section 18.

What I would like to do is have a macro check if a certain section exists e.g. section 3, if it does the macro should do nothing, but if it doesn't the macro should insert a row above the following section and put the section name in the newly inserted row in colum A e.g.

If the sheet looks like this:

Section 1
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
Section 3
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>

I would like to search for "section 2" and recieive the follwoing result:

Section 1
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>
Section 2
Section 3
<empty cell>
<empty cell>
<empty cell>
<empty cell>
<empty cell>

I don't know if this can be done by writing a macro as I am a complete noob but any help would be greatly appreciated.

Thank you very much for any assistance.

[mrice]

Try this.

Please Login or Register  to view this content.

[murzyn1975]

That works great. Thank you very much.