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!!
Bookmarks