Forum Discussion
Need to add blank lines
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.
Click Reply
Then click
Open full text editor
Then click
browse
to select the file you want to attach.
I don't have an option to browse for a file.
I have 9 columns of data and variable rows. I can do the sort, but I just need to insert blank rows between the groups.
- 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?
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" Maybe like in the attached file if you click the button in cell K1. The data is already sorted by column I and the macro executes the insertion of blank rows according to the groups in column I.
