I'm new to using VBA to sort a table, so I'm probably missing something basic . . .
I'm in the process of creating a spreadsheet to analyze membership data, and the current task I'm working on is to sort the list of meeting attendees by three criteria:
1. List the organization members first and non-members second ('1' in column 'A' is a member and '0' in column 'A' is a non-member)
2. Sort the members and non-members by how often person attends meetings (determined by their % meeting attendance, column 'G')
3. Sort by their last name (determined by column 'C')
When I modify any cell for a member; e.g., add a meeting location for the month of February, the list resorts immediately and mostly correctly. There are two problems with the sort operation:
a) The three online attendees with no name (so they are treated as non-members) appear above the members,
b) The member's last names are sorted in descending order, and the non-member's last names sort in ascending order. I want them both to sort in ascending order.
The list has headers on row 214 and the data for meeting attendance runs from row 215 to 285. The VBA macro is:
Yes . . . I know I can make this more sophisticated by only sorting the rows with data, but that is one of several a 'next steps'. Before I 'go there', I want to understand why the sort operation doesn't work properly.
Bookmarks