Michael O'Flaherty
asked on
XL insert a blank row whenever a cell in column L changes
I have a 300 row sheet.
Whenever there is a change in the values in cells in Column L I want a blank row inserted before the change
Col-L-with-rows-inserted.xlsx
Whenever there is a change in the values in cells in Column L I want a blank row inserted before the change
Col-L-with-rows-inserted.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could have also used the Subtotal wizard.
This inserts a row (and subtotal formula) after a change in a designated column. It also adds grouping icons to the left margin so that you can expand/collapse the groups.
If you don't need the subtotals, collapse to level 1 and delete them.
This inserts a row (and subtotal formula) after a change in a designated column. It also adds grouping icons to the left margin so that you can expand/collapse the groups.
If you don't need the subtotals, collapse to level 1 and delete them.
ASKER
True Rob.
ASKER
Thanks Wayne
Michael