Forum Discussion

LarryHarrison1988's avatar
LarryHarrison1988
Copper Contributor
Jan 07, 2022

Need to add blank lines

I am using Excel out of Office 360. I need to sort a table with dates and account numbers. I need to sort by the account numbers, then add a blank line between the different group of account numbers...
  • OliverScheurich's avatar
    OliverScheurich
    Jan 08, 2022

    LarryHarrison1988 

    Maybe like in the attached file if you click the button in cell K1. The data is already sorted by column E and the macro executes the insertion of blank rows according to the groups in column E.

Resources