Check Value above if different add row if same go to next row in range. If empty go to nex

I am looking for a simple macro to check the value in the cell above it. If the value is equal/same do nothing and check the next row down. If the values are different I need to add a row. I will run this macro starting in Column A, then Column B, and then Column C. This will be used to simply add a space between differing data and keeping the same data in a group.

Any help is appreciated.

Spreadlover

It sort of worked, but the results won't do. It put an empty cell underneath all of the changes, but I need a whole empty row. All of the data in a row needs to stay intact. With just an empty cell being inserted, it left the original data scattered.

Here is an example of how the workbook would be set up and the expected results. Right now I just Sort the original data. Then I separate each different product by inserting a new row. Example Book.xlsx

It worked perfectly. Thank you very much. Now I will just have to try and figure out what it is you did.

This should leave the blank row(s) as is if there any.

Please Login or Register  to view this content.

Originally Posted by jindon

This should leave the blank row(s) as is if there any.

Please Login or Register  to view this content.

This works as well Guru. Thank you.