title: Excel Macro Find in multiple columns
body: <p>I have two worksheets "Accounts" and "Mock up". In the first sheet, I have columns A to L and 1409 rows. In the second sheet, the user enters a value on cell B4. I have to search for this value in the range A1:A1409 in the first sheet. If the value is found in A100, then A100 to L100 will be assigned to cells B8:B11,B16:B19 and B22:B25 in the second sheet.</p>
  
  <p>If it is not found in the range A1:A1409, then I have to search in the range E1:E1409 and return A100 to L100 again to B8:B11,B16:B19 and B22:B25 in the second sheet.</p>
  
  <p>Trying to create a excel 2010 vba macro to accomplish this. Any help is appreciated.</p>
  
  <p>1st Sheet</p>
  
  <p><img src="https://i.stack.imgur.com/bToEp.jpg" alt="enter image description here"></p>
  
  <p>2nd sheet</p>
  
  <p><img src="https://i.stack.imgur.com/qMNFk.jpg" alt="Second Sheet"></p>
  
  <p>Regards,
  Ragav.</p>