Excel: Combining Two Lists Into One Master List

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.

This question generated 38 answers. To proceed to the answers, click here.

This thread is current as of March 20, 2014.

For more resources for Microsoft Excel