Insert multiple rows based on a criteria

Hi all,

Before I begin, please note I have never used VBA before

Essentially the title says it all, I have a big excel file with about 10k rows, and I need to insert rows at given points throughout the sheet. I have introduced a helper column that I use to delete rows (a simple logical check that returns true or false, then I filter by true values and delete those rows) and I wish to tweak this helper column to return true when the criteria is met for a row that I wish to insert a line ABOVE. However I have no idea how to implement this.

Can someone provide some simple VBA code that does something like the following:

Please Login or Register  to view this content.

Something like that, I know its not VBA code but I made it as generic as possible

Thank you!

Try such code:

Please Login or Register  to view this content.

substitute "B" with column where your criteria formula is.
(I used not 10000 but last entry in column A as a reference of rows to be examined)

Glad to hear so and thanks for marking thread SOLVED and for reputation point :-)