title: Macro VBA to Copy Column based on Header and Paste into another Sheet
body: <p>Background: This is my first time dealing with macros. I will have two worksheets that I’ll be using. The first sheet, ‘Source’ will have data available. The second sheet, ‘Final’ will be blank and is going to be where the macro will be pasting the data I’d like it to collect from the ‘Source’ sheet.</p>
  
  <p><strong>* I want the macro to find the specified header in the ‘Source’ sheet, copy that cell containing the header all the way down to the last row of existing data (instead of the entire column), and paste it onto the ‘Final’ sheet in a specified column (A, B, C, etc.). *</strong></p>
  
  <p>The reason why I have to specify which headers to find is because the headers in the ‘Source’ sheet won’t always be in the same position, but the ‘Final’ sheet’s headers will always be in the same position – so I CAN’T just record macros copying column A in ‘Source’ sheet and pasting in column A in ‘Final’ sheet. Also, one day the ‘Source’ sheet may have 170 rows of data, and another day it may have 180 rows.</p>
  
  <p>Although, it would probably be best to copy the entire column since one of the columns will have a few empty cells rather than to the last row of existing data. I’m assuming it would stop copying when it reaches the first empty cell in the column chosen which would leave out the remaining data after that empty cell in the column – correct me if I’m wrong. If copying the entire column is the best way, then, please provide that as part of the possible solution. I’ve attached an example of the before &amp; after result I would like accomplished:
  <a href="https://i.stack.imgur.com/yXyqE.png" rel="nofollow noreferrer">Example of Result</a></p>
  
  <p>Find Header=X, copy entire column -> Paste into A1 in ‘Final’ sheet</p>
  
  <p>Find Header=Y, copy entire column -> Paste into B1 in ‘Final’ sheet</p>
  
  <p>Etc..</p>
  
  <p>I’m sorry if my wording isn’t accurate – I tried to explain the best I could. It’d be awesome if someone could help me out on this! Thanks!</p>