Sonia Bowditch
asked on
Sort cells alphabetically
Hello Experts,
I have a spreadsheet which lists those who have access to a system with their access rights listed. However, the access rights are not in alphabetical order.
I need a macro to go through the spreadsheet and sort the data horizontally in alphabetical order.
I have attached an example of the data.
Thanks
Infosec36
SortData.xls
I have a spreadsheet which lists those who have access to a system with their access rights listed. However, the access rights are not in alphabetical order.
I need a macro to go through the spreadsheet and sort the data horizontally in alphabetical order.
I have attached an example of the data.
Thanks
Infosec36
SortData.xls
Why don't you use the sort build-in feature?
ASKER
I would have to go through every single line and the file is huge. It does not ignore the blank cells.
Thanks
Thanks
But what kind of sort do you like? You want to sort only the functions?
If possible upload an example of what you have an the expected result.
If possible upload an example of what you have an the expected result.
ASKER
I would like to sort the Functions only. I have attached a the updated file for your information.
Thanks.
SortData.xls
Thanks.
SortData.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfectly. Thank you.