How to create clickable button in the Excel Spreadsheet to count a vote for time table slot ?

Hi All,

I am trying to create the best way to input a survey of thousands sheets of training time availability for my colleague here in the office using MS Excel, see the attached Excel Spreadsheet.

the goal is to know the pattern of which time of the day is suitable or the best for majority of the people.

Rather than changing the cell value by manually incrementing number, how can it be simplified ?

by a click of a button in all of the cell possibly ?

Any help would be greatly appreciated.

Thanks
Availability.xlsx
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
 
ScriptAddictCommented:
Here you go.  

Just click on the button after selecting the day and it records a vote for you.

I think that's what you were looking for.

-SA
Vote.xlsm
0
 
Elton PascuaCommented:
How does your data source look like? Can you post a sample?
0
 
Anthony BerenguelCommented:
give this a shot...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
SteveCommented:
Are the surveys complete? Is this just about filling in the data as fast as possible?

If all the people in the survey are networked can do the survey in a manner to gather tha data eliminating the data entry all together.
0
 
Anthony BerenguelCommented:
just realized i forgot to attach my file
Availability.xlsm
0
 
Elton PascuaCommented:
If everyone uses Outlook, voting buttons could be an option for you as long as you have 32 or less options:

http://office.microsoft.com/en-us/outlook-help/create-polls-in-e-mail-messages-and-review-the-results-HP010080425.aspx

Open in new window

0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks man !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.