Hello Everyone,

I've searched the threads but was unable to get any of the VBA suggested solutions to work for me. I'm looking to insert a row when there is data change in column A. I would like it to go from the picture on the left to the one on the right. The Range for A is "A2:A400". Also, this might be asking too much but is there a way to also fill the row with a color when doing this? If not just the row insert. Thanks


Insert.png Insert 1.png