Excel Secret Voting System

Hi 

who can help me with this ?

this is for voting the board of an association. 

the voting spreadsheet is online on the homepage of the association.

to enable secret voting, the spreadsheet has a special column .

the voters have two choices : either making a X entry into the cell with the name or making an X entry into the random entries cell.

in case a voter is making the X entry into the random entry cell and hitting enter, the X disappears from the random entry cell and goes to a name cell randomly. 

so after the voting is completed, nobody can tell, if the X was dedicated or randomly chosen.

Hi Hekspoilr

This could be solved using VBA but

Given the fact that your voting spreadsheet is online, I'm afraid the macros would not perform on online excel files.

So a suggest you try to use Microsoft Forms.

Check the video tutorial for a quick inside the Microsoft Forms

and in your case at minute 2:00 the "Choice Option" is the one you might need.

https://www.youtube.com/watch?v=BOoTBzHM4fQ

 

I hope this helps you

Regards

Jeovany

Please,
Consider marking this reply as the answer to your question if it does so.
It will help others in the community with similar problems or questions.
Thank you in advance


Regards
Jeovany CV

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 14, 2024 Views 3,749 Applies to: