Forum Discussion
LarryHarrison1988
Jan 07, 2022Copper Contributor
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...
- Jan 08, 2022
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.
OliverScheurich
Jan 08, 2022Gold Contributor
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.
LarryHarrison1988
Jan 08, 2022Copper Contributor
I created a macro to sort the data.
It ended with the following.
End With
End Sub
If I paste the macro from your file, what should I do to make it work?