Hi all,
I would like to insert a empty row based on the criteria. The criteria is from row 3 onwards at column B. Column B is the unique ID of the line. If the unique ID at column B change when it move to the next row. It will insert a new row in between.
For example, in row 3,4. The column B ID are ABC.
In row5,6 and 7, the column B ID are DEF. Therefore it will insert a empty row between the 2 different ID.
The macro will end when it move to the last available row
Bookmarks