View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Jones[_2_] Steve Jones[_2_] is offline
external usenet poster
 
Posts: 1
Default hot to get a tally of the number of times a cell is clicked

I want to click a cell as a tally record to show how many times I have
clicked each cell. This will be used in an analysis spreadsheet of no. of
people enquiring about various products at our trade show. So I want to
display a number tally to be shown in each cell.
Currently I am writing the new number each time I enter in the cell - would
be much easier to just click the cell & let it increase the number count by 1
each click.
Thanks