Hi, I have a column of data that has duplicate info in it. What I would like to do is have a macro to insert 2 blank rows after it finds the next set of different data. The data varies from day to day.
EX: Some times there might only be 3 cells that has 1 kind of data, then the next 1 cell would have different data, then there might be 2 cells that have a different set of data, then there could be 1 cell that has different data.
See attachment.
Bookmarks