Using the example sheet provided, I am trying to sort the data in the worksheet by alphabetizing A3-A12. I have multiple sheets that need many formatting changes (this being one of them) and I am trying to make a macro that can make these changes for me quickly.
Thank you for any help in advance!
Best Regards
Book1345.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | First | Last | 1 | 2 | 3 | 4 | 5 | ||
2 | aa | bb | cc | dd | ee | ||||
3 | Bill | Patel | X | X | |||||
4 | Catherine | Gomez | X | X | |||||
5 | John | Wakefield | X | X | X | ||||
6 | Ali | Brown | X | ||||||
7 | Herrod | Smith | X | X | X | ||||
8 | Freya | Miller | X | X | X | ||||
9 | Isabelle | Cooper | X | ||||||
10 | Delilah | Harrington | X | ||||||
11 | Gina | Williams | X | X | X | ||||
12 | Eva | Lee | X | X | X | X | |||
Sheet2 |
Thank you for any help in advance!
Best Regards