Macro insert row copy value

M

Marco

In a range i desire insert a blank row and copy value if the value is
different from other range and repeat until last row.
es A2:A12
blu
yellow
orange
red
....
violet

C20: C last row or about 42000
blu
yellow
red
.....
violet
blu
orange
red
....
violet

Result :
blu
yellow
insert entire row copy orange
red
....
violet
blu
insert row copy yellow
orange
red
....
violet
..... until last row of column or cell 42000

Thanks in advance for any advice
 
Top