Two buttons - Randomly or Alphabetically

[jltjr75]

I have created a spreadsheet that helps a local Teacher set up a seating chart for her high school class.
It currently pulls from a list in another tab known as "mylist" which covers E3 - E40

I would like to add two buttons:

One that fills in the seats alphabetically in the order I have originally set the seating chart up (This is so she can learn her students name in the first few weeks)
The second button will randomly place the students in the seats (after she knows their names)

I would like it to place the First Name on the top line and then the Last Name underneath it on the bottom line (I haven't figured out how to do this yet automatically. Notice some names don't automatically do this because the wrap).
The alphabetically does NOT snake. It goes from front to back and then front to back...

[AlphaFrog]

Please Login or Register  to view this content.

[jltjr75]

Perfect AlphaFrog. I was able to embed those into my Buttons nicely. Is there a way to place the First Name on the top line and then the Last Name underneath it?

[AlphaFrog]

Is there a way to place the First Name on the top line and then the Last Name underneath it?

I don't understand what that means.

[jltjr75]

I don't understand what that means.

Sorry for the confusion.
I mean formatted like this:

First Name (on top)
Last Name. (underneath)

If so great, if NOT, I think she can get used to it.

Thank you so much for your support.
Jay

[AlphaFrog]

On the 1st Period sheet that has the names listed, use this formula in E3 and copy down.

=C3&" "&CHAR(10)&D3

Select column E and Format Cells\Alignment\Wrap Text.

That's it.