Macro to enter row where above cell is not exact

Hi,

I'm currently in the process of creating a major spreadsheet in which I input data and the end result is that it will automatically highlight the failures & email the relevent persons.

Though I'm stuck half way through... I've managed to create a macro to sort & a macro to insert the failures into a new sheet... problem is the data is in relation to many different things currently all squashed together. What I'm looking for is a macro that will automatically insert a row if for example A4 is different from A3. But I need this to loop over the range of cells in column A rather than individual cells.

Pulling my hair out here trying to get something to work - any help would be greatly appreciated.

Thank you in advance

Examples of before & Atfer attached.

Post an example workbook showing the BEFORE and AFTER needs. Make sure the layout is correct, don't oversimplify the example.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.