Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
I'm trying to help a friend automate assigning tee times for a high school league invovling boys and girls.
I have a Boys list and a Girls list. The lists are unequal in size, with the boys having more players. I need to combine both lists into a master list to assign tee times. Each has a worksheet named Boys/Girls.
The criteria is to alternate, in groups of three, from each list, until all names are listed in the master list.
Like
Boy1
Boy2
Boy3
Girl1
Girl2
Girl3
Boy4
Boy5
Boy6
Girl4
Girl5
Girl6
I suppose, if worse comes to worst, I could manually do
=BoysList!A1
etc.
Any advice welcome.
I have a Boys list and a Girls list. The lists are unequal in size, with the boys having more players. I need to combine both lists into a master list to assign tee times. Each has a worksheet named Boys/Girls.
The criteria is to alternate, in groups of three, from each list, until all names are listed in the master list.
Like
Boy1
Boy2
Boy3
Girl1
Girl2
Girl3
Boy4
Boy5
Boy6
Girl4
Girl5
Girl6
I suppose, if worse comes to worst, I could manually do
=BoysList!A1
etc.
Any advice welcome.