MS Excel: Randomize column of strings into a grid of strings

by Rubin|Published July 23, 2021

I have a MS Excel sheet with 100 names in a single column.

On another sheet, I have a 10 x 10 grid of cells from which I want to randomly assign a name from the column.

Is there a relatively easy way to achieve this, or will it involve VBA type work?