title: Excel VBA - Using ComboBox value to copy data of multiple cells to an other sheet
body: <p>Sheet1 = Contains Fill in Data
  Sheet2 = Contains All the information</p>
  
  <p>I am using Sheet 2 Column A2:A81 as Combobox1 Items,
  I need when an item is selected, the following cells of the same row will be copied to sheet1 eg;</p>
  
  <hr>
  
  <p>Sheet 2:</p>
  
  <pre><code>Shop1 Germany 11111111
  
  Shop2 Italy 2222222
  
  Shop3 UK 33333333
  
  Shop4 Russia 44444444
  </code></pre>
  
  <hr>
  
  <p>Combobox Item Selected: [Shop4]</p>
  
  <hr>
  
  <p>Data from Sheet 2 is copied to sheet1</p>
  
  <p>Sheet 1:</p>
  
  <pre><code>Shop4 Russia 44444444
  </code></pre>
  
  <p>anyone know how can I execute this ? </p>