Generate unique list from range with button

[Marty_l]

Hello everyone,

I've tried a few formula found on the web, I try to adapt to my need but wasn't able to get the result I needed.
Example:
formule.PNG

My document contain different questions and user have a drop down to choose possible answer from (my grid in is in worksheet 6) and when an answer is chosen there is a validation done, that work fine.

I've added a button that reset the range so user can try again.

I would like the reset button to randomise range B4:B14 with unique name from a specific list (in worksheet 6 A2:A14)

Menu2.PNG

I hope my explanation are clear, I'm pretty good with Excel formulas but VBA isn't my cup of tea.

Thank you in advance,

EDIT:
added original document as suggested screenshot has been taken from 2nd sheetrésumé termes_Question.xlsmAttachment 424861Attachment 424861