title: excel auto full table, papercut
body: <p>First let explain my scenario. </p>
  
  <p>I had a windows server with PaperCut free edition. It give as output an "papercut-print-log-all-time.csv". That output is always open by the service that every time anyone print it count and document who did it and many other information.</p>
  
  <p>Now, I'm looking to make some type of excel table that every time I open the excel would "automat add all the new register to the new form to make some graphics about usage.</p>
  
  <p>where does the trick is?
  I wont want that every time I open had to pull down the formula to manually update the new registers.</p>
  
  <p>I guess will need to make some kind of macro (never do before but know c# and vb) but still don't know if with dynamic table and some tricky formula could make that..</p>
  
  <p>An example of the "papercut-print-log-all-time.csv" format is:</p>
  
  <pre><code>Time    User    Pages   Copies  Printer FileName    Client  PaperFormat Lenguaje    Duplex  GrayScale   Format
  11/27/2012 11:29    Mberiguette 2   1   Printer1    Microsoft Office Outlook - Memorando    client-pc1  Letter  PCL6    NOT DUPLEX  GRAYSCALE   120kb
  11/27/2012 11:30    mabreu  1   1   Printer1    PDF Print   client-pc2  Letter  PCL6    NOT DUPLEX  GRAYSCALE   58kb
  11/27/2012 11:30    mabreu  1   1   Printer1    PrintTest   client-pc2  Letter  PCL6    NOT DUPLEX  GRAYSCALE   21kb
  11/27/2012 11:35    mabreu  1   1   Printer2    PrintTest   client-pc2  Letter  PCL6    NOT DUPLEX  GRAYSCALE   21kb
  11/27/2012 11:35    Mberiguette 1   2   Printer2    Microsoft Word - Entrega factyras de Proveedor.doc  client-pc1  Letter  PCL6    NOT DUPLEX  GRAYSCALE   51kb
  </code></pre>
  
  <p>thanks for any support.</p>