Excel Input question

Copper Contributor

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

0 Replies