title: How to copy specific parts of a table from a sheet to another
body: <p>I'm trying to get some details copied in Excel from Sheet 1 columns 1-5 to Sheet 2 columns 1-4, but only for lines that include text or values on sheet one under a specific column (in this case, Column 2). There are other columns in between, so I need to be able to use exact columns rather than A:D for example. 
  Example of what I'm trying to achieve:</p>
  
  <p><a href="https://i.stack.imgur.com/qtoZ8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qtoZ8.png" alt="Excel screenshot of dummy data"></a>  </p>
  
  <p>I have tried using a simple IF function with A:A&lt;>"" so it would include any rows that have any data in them, however this does not seem to copy as I need and occasionally based on my attempts i also get circular reference errors.  Additionally, I’m not sure how to make sure this gets pasted at the bottom of a table that will expand with each addition. </p>
  
  <p>I realize a probably easier option would be to simply copy Sheet 1 entirely and use a filter on row 1 to deselect Blanks on A:A, but the sheet has so much more info that it would be a waste, and additionally info is constantly added so I need something scale-able. It also occurred to me now that by doing this i would include info from the "header" and "footer", basically a frozen pane - which I do not need. </p>
  
  <p>Could this be done via a simple function, or would it require a Macro?</p>
  
  <p>Please keep in mind I'm rubbish at programming, just trying to make my life easier and learn as I go. A lot of excel forums help but still I'm no coder. I can understand to a pretty big degree what the code does and can adjust accordingly though :)</p>