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
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