Insert Row Based Upon Cell Value

[carguy935]

Hey guys,

I'm trying to write a macro that will insert a blank row below a cell/row if it sees "Insert" in Column P.

The range of the data is from P4:P1999 where "Insert" will be found. Inbetween the "Insert" values there are "False" values so something with a loop until "" will work just fine.

Basically looking for:
----------------------------------------
False
False
Insert
False
----------------------------------------
Becomes:
----------------------------------------
False
False
Insert

False
----------------------------------------
The "Insert" & "False" values are formula based from an IF function.

Thanks in advance!

Gabriel

[royUK]

Welcome to the Forum. Please don't use unnecessary words in your titles. The purpose of titles is to help users search the forums, statements like "need help" make the search less effective.

[royUK]

Try this

Please Login or Register  to view this content.

[carguy935]

Edited, not solved.

[carguy935]

Correction, its giving me a problem by doing the following:

Before:
------------------
Insert
Insert

Insert
------------------

After
------------------
Insert

Insert


Insert
------------------

Its inserting a row after the first "Insert" as it should, but then inserting a row before the other "Insert" cells instead of after.

Any ideas?

[royUK]

just change to this

Please Login or Register  to view this content.