title: Copy Cells from a Column to another sheet, only if a cell in the next column is not blank
body: <p>So my problem is this:
  I have a column that generates OfferCodes (so all cells contain a formula).lets say it's column A.
  columns B, C have other data like customer, and issue date etc. 
  Column D is OrderConfirmation and the user fills it in (the date) only when the quotation is confirmed.</p>
  
  <p>What I need is to copy (in another worksheet) a list of column A (QuoatationCodes) '(and other columns, but if I know how to do it for 1 column I suppose I will be able to do it for the rest as well)
  only if it gets a confirmation date in column D. (basicaly generate an order list where in the new sheet generates unique production-order codes.</p>
  
  <p>What I have now is a list of production-orders with blank rows for the Offers that have not been confirmed)
  I need this to refresh automatically/dynamicaly. either on new data entry ( In column D) or by a control button ...</p>
  
  <p>Note that (source) column A will be ever expanding and data entry on Column D (where we have our criteria eg.not blank) is on a daily basis.</p>
  
  <p>Thank you in advance,</p>
  
  <p>Angelos</p>