Sorting rows by alphabetizing column E

[ABabeNChrist]

How to sort rows 3:855 by alphabetizing column E

[HansV]

Manually or using VBA?

[ABabeNChrist]

vba

[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.

[ABabeNChrist]

Works great thank you Hans