random names from one sheet to another

[Sheepkin_Coat]

i have a list of 51 names in column A, i want to pick the bottom ten names randomdly on another sheet

like this Sheet2

Column A Column b
Name Name
Name Name
Name Name
Name Name
Name Name

how can i do this

[davesexcel]

No idea what you are talking about, if the bottom ten are picked then it would not be random.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Sheepkin_Coat]

in sheet one there is 51 names, i want to randomdly pick the bottom 10 teams like in sheet2