title: Sort Two Randoms Lists So They Match
body: <p>I have one sheet with four cols of data. Col A and Col G display company names.</p>
  
  <p>The data that is located on the same row, in cols A and G, do not match.</p>
  
  <p>After sorting / alphabetizing Col A and Col G I need to have the data match on the same row. Col B data goes with data in Col A ... Col H data goes with data in Col G.</p>
  
  <p>Some of the rows will match after running a macro ... most will likely not match and will require blank rows between the non-matches</p>
  
  <p>Your assistance for a VBA macro is greatly appreciated. I have no idea how to accomplish this. Thank you.</p>
  
  <p>Download workbook : <a href="https://www.amazon.com/clouddrive/share/CrJbwvdwbk8wdM2kAWegZnu2XAuOaE0CdnJKdMoJwJD" rel="nofollow noreferrer">Download</a></p>