Link to home
Start Free TrialLog in
Avatar of Michael O'Flaherty
Michael O'FlahertyFlag for New Zealand

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
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael O'Flaherty

ASKER

Excellent
Thanks Wayne

Michael
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.
True Rob.