Forum Discussion
Solved
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...
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.
That will work.
I need to insert a line based on my column "E"
I need to insert a line based on my column "E"
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.
- I was able to edit the macro and make it work for my document.
Thanks for your help. I created a macro to sort the data.
It ended with the following.
End With
End SubIf I paste the macro from your file, what should I do to make it work?
