Excel Input question

%3CLINGO-SUB%20id%3D%22lingo-sub-3316557%22%20slang%3D%22en-US%22%3EExcel%20Input%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3316557%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20even%20sure%20its%20possible.%3CBR%20%2F%3EIm%20working%20on%20setting%20up%20a%20excel%20sheet%20for%20a%20car%20show%20for%20a%20friend%20of%20mine.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20are%20wanting%20to%20be%20able%20to%20just%20enter%20data%20into%201%20cell%20and%20have%20it%20auto%20add%20to%20the%20corresponding%20cell.%3CBR%20%2F%3EFor%20example%20Enter%20Data%3A%3CU%3E%20%2312%20%3C%2FU%3Eand%20have%20it%20find%20car%20%2312%20and%20add%201%20to%20the%20count%20in%20column%20next%20to%20that%20car.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3Ethat%20way%20the%20ladies%20helping%20wont%20have%20to%20hunt%20for%20each%20car%20number%20to%20add%20%2B1%20to%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20isnt%20possible%20what%20about%20making%20a%20cell%20into%20a%20button%20so%20that%20when%20they%20click%20it%20it%20%2B1%20and%20shows%20the%20new%20total%3F%3CBR%20%2F%3Eso%20that%20they%20would%20simply%20scroll%20down%20the%20list%20and%20click%20the%20button%20to%20auto%20%2B1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3316557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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