Inserting extra row based on condition

I have an Excel 2007 worksheet with over 4000 records.

The key to most problems with the worksheet records is the regularity of the format of the record set and the larger the record set the more likely it is that some entries will be in a non-standard format.

When a search is done and if the row contains the words "Demographic info", the following row is blank.

My requirement is that if the "Demographic info" words are matched, then there should appear two blanks rows, instead of just one.

I have attached a before and after sample.

Could anyone assist with a solution for the attached please?

Hello nobleprince,

I have added the following macro to the attached workbook. It is run by clicking a button on the "Before" sheet. You will probably need to change the worksheet name in the macro for your actual workbook.

Please Login or Register  to view this content.