Hi all,
I would like to create a macro to automatically insert a blank row between data when the value in column D changes.
Fe. the 1st 100 rows column D has value 'G', but in row 101 the value in column D changes to 'H' for the next 120 rows ..
What formula do I need to write in my macro in order for excel to automatically insert a blank row every time the value in column D changes.
Thank you.
Jeroen
Bookmarks