+ Reply to Thread
Results 1 to 2 of 2

PLEASE HELP! Need buttons to populate tally sheet

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    Sacramento
    MS-Off Ver
    2010
    Posts
    1

    Exclamation PLEASE HELP! Need buttons to populate tally sheet

    I have been reading several threads here regadring tally sheets and they all have components that I need, but I have never used Macros and I'm not sure how to make heads or tails of it all. I know Excel basics pretty well and have minor experiences with various programing languages, but need help here! Thank you in advnace!

    So I work on a help desk assistancing users via email and phone. I current use a paper tally sheet to keep track of various categories divided into emails and phone calls. An example of the paper tally sheet I currently use is attached below.

    I would like to transition to an electronic version of that tally sheet, so I also attached an example of what I am trying to create (Help Desk Tally Sheet.xlsx). Sheet 1 has the buttons that would replace the actual hand-marked tallies. Sheet 2 has the running total. I want to use Macros so that each time I press a button, it will add 1 to the the running total in the appropiate catogory. I would also like that each button press will be recorded with time stamp. I am not sure if I am explaining myself clearly, but hopefully the attached files explain what I need.

    I'm on Windows 7 with Excel 2010.
    Any help is much appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,642

    Re: PLEASE HELP! Need buttons to populate tally sheet

    I couldn't understand what you wanted to do on the "Help Desk Tally Sheet", so I updated the "Paper Tally Sheet" to include spinner buttons. I think that it will be pretty much self explanatory, however let me know if you have questions.

    Update of Example Paper Tally Sheet.xlsm

    The file is "macro enabled". Hope that this helps.

    If this answers the original question please mark the thread as "Solved". If anyone has been helpful please add to their reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  2. Help With A Tally Sheet
    By JOB Dave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 09:55 PM
  3. [SOLVED] ?Tally chart using buttons???
    By smithymcsmithy in forum Excel General
    Replies: 17
    Last Post: 09-05-2012, 07:23 PM
  4. [SOLVED] Trying to create a tally sheet
    By Nemo5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2009, 11:28 PM
  5. [SOLVED] create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1