title: Making Excel macro for fast data entering ::: VBA ::: Excel :::
body: <p>I have a job to enter survey results (in paper form) to excel.
  I've never written any macro in Office :(</p>
  
  <p>Here I what I basically need:</p>
  
  <ol>
  <li>I have predefined columns (|A|B|...|AG|AH|)</li>
  <li>All surveys are grouped into groups. All surveys from same group have few (like predefined) same columns. It's always same columns that 'define' group</li>
  <li>All other survey answers are in numerical type [1..10].</li>
  <li>Columns are not in same order as answers in servey</li>
  <li>I want macro that will take my input (for example '1575'), and first place predefined values to that 'group' to |A| |B| |C|, and then |E| = 1, |D| = 5, |F| = 7, |G| = 5, and automatically start entering next row.</li>
  </ol>
  
  <p>Anything that will give me a clue how to write this macro in more than welcome</p>
  
  <p>Huge thanks for reading this... </p>
  
  <p>EDIT1: I suppose question is not clear enough...
  I need macro that will read my keyboard input ( '1575' ) and write integers '1' '5' '7' and '5' to predefined rows. For now, I have an idea to make a form, but I need event handler that will change focus to next input when I press a key, as I want to avoid pressing TAB all the time...</p>