title: VBA Copying data from one table to another and rearranging columns
body: <p>I have 99 columns in one table called <code>tbl_raw</code>. I need to copy 96 of those columns into another table with the same exact header names, but they are rearranged in a different order. What is the most efficient way to do this? </p>
  
  <p>The only way I knew was:</p>
  
  <p><code>raw_data.Range("tbl_raw[EMPLOYEE]").Copy
  processed_data.Range("tbl_processed[EMPLOYEE]").PasteSpecial</code></p>
  
  <p>However, this would take a lot of code (96 * 2 = 192 lines) and I wasn't sure if there was a more efficient way to do it.</p>
  
  <p>I tried to use <a href="https://www.thespreadsheetguru.com/blog/2014/6/20/the-vba-guide-to-listobject-excel-tables" rel="nofollow noreferrer">https://www.thespreadsheetguru.com/blog/2014/6/20/the-vba-guide-to-listobject-excel-tables</a>, but I couldn't figure out a way to do it with that information either.</p>
  
  <p>Any guidance would be greatly appreciated.</p>