Not even sure its possible. Im working on setting up a excel sheet for a car show for a friend of mine.
We are wanting to be able to just enter data into 1 cell and have it auto add to the corresponding cell. For example Enter Data: #12 and have it find car #12 and add 1 to the count in column next to that car.
that way the ladies helping wont have to hunt for each car number to add +1 to it.
If this isnt possible what about making a cell into a button so that when they click it it +1 and shows the new total? so that they would simply scroll down the list and click the button to auto +1