title: Excel: Autofill (copy) whole row when value is entered in 1st column
body: <p>I am using Excel 2010 and looking for a way to autocomplete the whole row of a table when the unique identifier in the first colum is entered. For example a kind of log book for a warehouse:</p>
  
  <p>Each row of the table contains one item with a unique ID, description, category, prize and date when it was last sold. Every time an item is sold, I add a new row where ID, description and category keep constant but the prize and date varies.
  How is it possible to enter the ID in the first column and have the description and category in the second and third column auto-filled if there already exists an older entry for this ID?
  Additionally, I would prefer the auto-filled cells to contain values not formulas (so that newer entries for one ID do not change if and older entry for that ID should be changed later on).</p>
  
  <p>I have no clue on VBA but maybe it is possible without? Thanks in advance!</p>