title: Copy Row If Cell Range Are Not Blank
body: <p>I wonder whether someone may be able to help me please.</p>
  
  <p>I have an Excel (2003) spreadsheet called 'Input' with data in columns B to N. What I would like to be able to do is if there is text in any of the cells in column B, I would like to copy the row but only columns 'B' 'I' and 'N' and paste them into my second spreadsheet called 'Output' at cell ref B2.</p>
  
  <p>If at all possible, once the information has been pasted, I'd like to add the word 'Scheduled site' in column 'E' on the 'Output' sheet if the cells in column 'B' have text in them. </p>
  
  <p>I've been doing this manually, and it takes quite some time to do.</p>
  
  <p>I just wondered whether someone may be able to show me please how I can automate this.</p>
  
  <p>Many thanks</p>