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 10, 2022Copper Contributor
I was able to edit the macro and make it work for my document.
Thanks for your help.
Thanks for your help.