Hello,
This is my first post on here so sorry if this is posted in the wrong section but I figure you can never go wrong in general right? The question I have is I have an excel sheet that I want to use to enter survey results. We are using 1 - 5 for a scale as unsatisifed to extremely satisifed, some questions use 1 for yes 2 for no and 5 for no reply, and some use 1 for yes (there are four answers and the user can only select one). The question I have is there will only ever be one character entered into a cell is there anyway to tell that there has been a character entered and automatically move to the next cell (downward)?
TIA
Bookmarks