title: VBA Excel Script to copy rows with data from one worksheet & paste into another with out overwritting
body: <p>Excel 2007</p>
  
  <p>I'm trying to run a VBA script that will copy a list of sales Ledgers from one worksheet titled MSL with the columns DATE, INVOICE NO, COMPANY NAME, TOTAL, SUB-TOTAL, NETT, VAT.</p>
  
  <p>1st problem i'm having is i only want to copy rows 2 and onward which contain a record and this number will change each month depending on sales.</p>
  
  <p>e.g. Jan has 30 rows
       Feb has 24 rows
       Mar has 40 rows</p>
  
  <p>Next i need to paste the data in to a new worksheet titled "SalesDB" with the same columns DATE, INVOICE NO, COMPANY NAME, TOTAL, SUB-TOTAL, NETT, VAT.</p>
  
  <p>Next problem im having is the data is overwriting.</p>
  
  <p>Thanks for any help
  <em>will be out for the next hour collecting kids from school</em></p>