title: Excel macro, to copy and paste a multiple cells based on another cell value?
body: <p>I have 2 worksheets, I need to update with data from another worksheet I receive every week. I wonder if its possible
  to copy the data into the excel file with the 2 worksheets I need updating and then run a macro that selects the cells i need to output to the other worksheets.
  I don't know if i am being clear enough, below is an example. </p>
  
  <p>For example I have the following sheet, I need to look though the "name" column and if the name begins with "sony", copy the cells i need to the sony worksheet, if it begins with Samsung copy the cells i need to the Samsung sheet and so on.</p>
  
  <p>I suppose that copying the whole row then deleting the columns I don't need will also work. </p>
  
  <p><strong>Main Sheet Example</strong>
  <pre>
  Name            --- Type --- Extra --- Year --- Power 
  Sony TV         --- LCD  --- CAM   --- 2009 --- 90W<br>
  Samsung TV      --- LED  --- WIFI   --- 2010 --- 70W 
  Sony TV         --- LCD  --- SAT   --- 2011 --- 90W 
  Hitachi TV      --- LED  --- CAM   --- 2012  --- 70W </p>
  
  <p>Sony Sheet Example
  Name   --- Type  --- Year --- Power </p>
  
  <p>Samsung sheet Example
  Name   --- Type  --- Year --- Power </Pre></p>