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

Posted on 2012-08-23
Last Modified: 2012-08-23
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.

    LVL 8

    Expert Comment

    by:Elton Pascua
    How does your data source look like? Can you post a sample?
    LVL 10

    Expert Comment

    by:Anthony Berenguel
    give this a shot...
    LVL 24

    Expert Comment

    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.
    LVL 10

    Expert Comment

    by:Anthony Berenguel
    just realized i forgot to attach my file
    LVL 11

    Accepted Solution

    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.

    LVL 8

    Expert Comment

    by:Elton Pascua
    If everyone uses Outlook, voting buttons could be an option for you as long as you have 32 or less options:

    Open in new window

    LVL 6

    Author Closing Comment

    by:Senior IT System Engineer
    Thanks man !

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now