Prev: How do I change the comment default format to include date?
Next: Counting a Column
From: Russell Dawson on 10 May 2010 12:32
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.
From: Don Guillett on 10 May 2010 13:51
The archives want to see your final answer

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Russell Dawson" <russell.dawson(a)discussions.microsoft.com> wrote in message
news:B645C670-5BD4-4DD2-81CC-531DA26AD23B(a)microsoft.com...
> 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.

First  |  Prev  | 
Pages: 1 2
Prev: How do I change the comment default format to include date?
Next: Counting a Column