dimanche 28 février 2021

How to show random team member name from list or range using VBA?

Excel sheet

Hi experts,

I have a list of members in an excel sheet as shown in the image (from A2 to A21). I want a VBA code that randomly select a name from this range and displays it in cell E2. My requirement is that all the members must be covered and when we click and no member name should repeat. That is, I need to click the macro button exactly 20 times which should show random member name in E2 cell without repeating. I got so many codes to generate unique random number but I couldn't find any to link it with my requirement. Any help please?




Aucun commentaire:

Enregistrer un commentaire