I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course keeping all the other columns in tact.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Facts
Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Peter SS, I posted another thread and included a file in my Dropbox but it seems to hav disappeared. Can I supply you guys with a file that has some vba code that does 80% of what I want it to do and have an expert see if he/she has a solution. Not sure I got the file out or even the post.
Upvote
0
Not sure what you mean here by clever solution.
Did my file get shared in Drop Box. Is it clear what I am asking for?
Upvote
0
Yes it was, he was very helpful with that fix. I hope he sees my new request.
Upvote
0
Upvote
0
I have a list of 160 golfers, 80 couples that I want to make 40 teams of 4 somes but each team has to have two couples. Each player has a different handicap. I have code from another gentleman that allows me to list all the players and number the first 31 couples and then it makes up the 40 teams but it does not keep the couples together. I know this sounds complicated but I could send the file, you can run it and see the results. I was sure I put this in my Dropbox as suggested but I have not heard anything.
Upvote
0
