title: Copying Data Based on matched column headers
body: <p>I have two workbooks. Once contains dynamic data which is updated on a weekly basis (dynamic pivot table). The other contains a master sheet within which this data needs to be inputted. </p>
  
  <p>Within VBA, how can i copy and paste the data based on a match on the headers? The two tables have the same headers (being dates). Sheet one has headers located starting from cell G6 and this increases on a weekly basis as new dates added. </p>
  
  <p>i would like to write a macro which will copy and paste the data from one workbook to another if the two headers match.</p>
  
  <p>Kind regards </p>
  
  <p>D</p>