Hello,
I am VERY new to the concept of using Macro's and really have no idea how to write a code for what I would like to do. I am taking a course on them next month, but unfortunatly that is not soon enough to help me with this problem.
I run an information desk at UBC and we are trying to move to an electronic statistical recording process. Currently our volunteers manually record the number of times they are asked a specific types of question. This work well, but means that at the end of the year I have to manually add up several hundred days work of data.
What I would like them to be able to do is open an excel file which has a worksheet for each day of the month. On each worksheet there would be a chart that has the day broken down by hour in one column and by question type (IE directions, lost and found, first aid). There would be a button associated with each type of question for each time frame.
I want the volunteers to simply be able to click on the button every time they are asked that type of question.
I am hoping that there is a macro that will add up the number of times a button is pressed and input that data into a separate worksheet.
Anyone have any tips on how I might do this?
Bookmarks