[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 937
  • Last Modified:

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
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
1 Solution
 
Elton PascuaCommented:
How does your data source look like? Can you post a sample?
0
 
Anthony BerenguelCommented:
give this a shot...
0
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Anthony BerenguelCommented:
just realized i forgot to attach my file
Availability.xlsm
0
 
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:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now