Forum Discussion
Need to add blank lines
- 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.
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.
- LarryHarrison1988Jan 10, 2022Copper ContributorI was able to edit the macro and make it work for my document.
Thanks for your help. - LarryHarrison1988Jan 08, 2022Copper Contributor
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?
- OliverScheurichJan 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.
- LarryHarrison1988Jan 08, 2022Copper ContributorThat will work.
I need to insert a line based on my column "E" - OliverScheurichJan 08, 2022Gold Contributor
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.
- LarryHarrison1988Jan 07, 2022Copper Contributor
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.