Automatically shorten a list of names
 

I have a list of 36 names in column A. When 1 name is randomly selected it is
removed form the the list, written in another cell and the original list
shrinks to 35. When the operation is repeated another name is randomly
removed, written in another cell and the list is again decreased. This
constant decrease could go on until every name is used only once. Any ideas
please.

Automatically shorten a list of names
 

If you are looking for a non-VBA solution..select one cell from the 36 cells
you have and move the cursor towards the selection border. When the cursor
turns to a 4-side pointer; click and drag the cell content ....

--
Jacob


"CJ" wrote:

I have a list of 36 names in column A. When 1 name is randomly selected it is
removed form the the list, written in another cell and the original list
shrinks to 35. When the operation is repeated another name is randomly
removed, written in another cell and the list is again decreased. This
constant decrease could go on until every name is used only once. Any ideas
please.

Automatically shorten a list of names
 

Arrange the names in random order once and then start at the top and
work your way to the bottom.

CJ wrote:

I have a list of 36 names in column A. When 1 name is randomly selected it is
removed form the the list, written in another cell and the original list
shrinks to 35. When the operation is repeated another name is randomly
removed, written in another cell and the list is again decreased. This
constant decrease could go on until every name is used only once. Any ideas
please.