title: VBA Excel - Search rows for string and if found copy entire cell to a specific location
body: <p>I got 3000 rows of data in Excel.
  Each row contains the same type of information but not in the right order.
  What i need to do is to gather the same type of information under the same column.I would like to create a macro that is going to:</p>
  
  <ul>
  <li><p>Search a row for a partial string (some values have similar strings but fall under different categories)</p></li>
  <li><p>If the string is part of a cell copy the entire cell in a
  new location </p></li>
  <li><p>Repeat for the next row</p></li>
  </ul>
  
  <p>Thanks in advance</p>