Sorting rows by alphabetizing column E

User avatar
ABabeNChrist
SilverLounger
Posts: 1805
Joined: 25 Jan 2010, 15:57
Location: Conroe, Texas

Sorting rows by alphabetizing column E

Post by ABabeNChrist »

How to sort rows 3:855 by alphabetizing column E
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller

User avatar
HansV
Administrator
Posts: 73825
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sorting rows by alphabetizing column E

Post by HansV »

Manually or using VBA?
Regards,
Hans

User avatar
ABabeNChrist
SilverLounger
Posts: 1805
Joined: 25 Jan 2010, 15:57
Location: Conroe, Texas

Re: Sorting rows by alphabetizing column E

Post by ABabeNChrist »

vba
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller

User avatar
HansV
Administrator
Posts: 73825
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sorting rows by alphabetizing column E

Post by HansV »

If you want to sort row 3 with the rest of the rows:

Code: Select all

    Range("3:855").Sort Key1:=Range("E1"), Header:=xlNo
If row 3 contains headers that should not be moved, change xlNo to xlYes.
Regards,
Hans

User avatar
ABabeNChrist
SilverLounger
Posts: 1805
Joined: 25 Jan 2010, 15:57
Location: Conroe, Texas

Re: Sorting rows by alphabetizing column E

Post by ABabeNChrist »

Works great thank you Hans
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller