Insert rows when data changes
Many thanks for the answers.
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"Russell Dawson" wrote:
In a column of periodically changing names in alphabetical order (col A) €“ I
need to insert a row after each change in initial letter. So when the names
have been sorted when the initial letter of the name changes from A to B as
in Aldred to Bute there is a blank row inserted after Aldred.
It would be nice if the code could include the instruction to sort the names
first rather than that being a separate action. Sort by column A to include
other related data in columns to F.
Thanks
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
|