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.
How can I submit my file for a better example?
I have done the sort and added your text below "End With"
Do I need to edit any of that?
Click Reply
Then click
Open full text editor
Then click
browse
to select the file you want to attach.
- 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.
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.
