I have an ID format checker that has a row of cells that can only have one specific kind of character in each cell, and then all characters are compiled in order into another cell to create the correct ID#. If an incorrect character is entered, it highlights the cell yellow to indicate it's incorrect. I want to be able to type a character into the first cell and it automatically tab over to the next cell. So let's say I type the number "3" into cell A2. Instead of having to press tab or the right arrow key, I want it to automatically make the next cell to the right the active cell. So if I type "G" into cell A2, the next time I type a character it goes into B2, and then next time I type a character it goes into C3, so on and so forth.
Any suggestions?
Here's a copy of the sheet I'm using.
https://docs.google.com/spreadsheets/d/1mWxDIXsuKuxBziTkoUdufRxp_wyO035ENfltTTwetIs/edit?usp=sharing
Best Answer
This is highly impossible to jump from an active cell into a neighboring active cell without the medium (keyboard/mouse). The script just wouldn't know when you wish to jump because the state of the active cell is technically empty (even if you already typed in something) to the point when the active cell gets inactivated/out of the focus.
For such task, you will need 3rd-party script/macro which will mimic the action of pressing right arrow key at specific intervals (like every 5 seconds). Check out AutoHotKey.