title: Copy and sort data from one sheet to another, based on cell values
body: <p>I have searched a lot of similar topics and have had some help but I cant find a way to do what I need (probably because of my limited experience with excel and vba), so here it goes: </p>
  
  <p>I have a (Source)sheet 'offers' , which is populated daily, with the columns below:</p>
  
  <pre><code>columns:     b           c           d           e          f            g
   header:  offercode   issue dt    worktype    customer   sent dt    confirmation dt
            xxx.xx.       1/1/14      MI          john      1/1/14       3/1/14
            aaa.aa.       1/1/14      MD           bob      2/1/14
            bbb.bb        2/1/14      SI          peter     2/1/14       3/1/14
  </code></pre>
  
  <p>what I need is to copy all rows that get a confirmation date (not blank) in another sheet"production orders"(destination)
  where I generate production order codes and input other kind of data :</p>
  
  <pre><code>columns:     b           c            d           e          f            g
   header: offercode  productioncode  worktype    start       end     confirmation dt
            xxx.xx.       1/1/14       MI         5/1/14                  3/1/14
            bbb.bb        2/1/14       SI         6/1/14                  3/1/14
  </code></pre>
  
  <p>note that column b and b &amp; c contain formulas (generates offer codes)</p>
  
  <p>my problem is that data is populated daily, and offers(Source Sheet) should be sorted by issue date and once they get confirmed(input confirmation date->non blank) they should be copied in the other sheet but sorted (or polulate the next empty row) by confirmation date eg:</p>
  
  <pre><code> columns:     b           c              d            e          f            g
   header: offercode  productioncode    worktype      start       end     confirmation dt
            xxx.xx.       XX.XXX.         MI         5/1/14                  3/1/14
            bbb.bb        BB.BBB          SI         6/1/14                  3/1/14
            aaa.aa.       AA&gt;AAA          MD                                 4/1/14
  </code></pre>
  
  <p>another issue is how often or when is the second (Destination Sheet) list refreshs with new data, my guess is that a control button click after every data entry instance would work (and make sure that the list is up to date)</p>
  
  <p>thank you in advance,</p>
  
  <p>Angelos</p>