I have got the job of creating a spreadsheet to record about 1,600 survey results. I am trying to think of the easiest way to record them. The survey has open and closed questions. So i was thinking if its possible to create a macro that would add one to the total each time it is clicked like a tally but have no clue for the open questions.
Any help appreciated