title: Looping until blank column
body: <p>I am putting together some VBA code which i think needs a loop.  Loops are often my biggest weakness with VBA and I need some assistance.</p>
  
  <p>I have a text file which i import into an excel spreadsheet.  The length of how many columns and rows and down will vary day to day.
  For example today's file might have data in columns A - H, tomorrow it might be A : P.  Each typical row count will be around the 200 mark, so not to long.</p>
  
  <p>In essence im trying to make one long list in column A from all the data spread over multiple columns.
  Im looking for a loop that checks if the column has data in it, if it does it then copies the data into the bottom of the data in column A.
  So for illustration purposes  say the data goes out to column G, it will copy B1, xl down, find the first empty row in A and paste, then do the same for C, stopping after column G.</p>
  
  <p>I hope I’ve been clear when writing this.
  Thanks in advance
  Matt </p>