title: Copy data from multiple excel sheets and append that to a single excel sheet using VBScript
body: <p>The scenario is as follows:</p>
  
  <ol>
  <li>I have an excel (.xls) file with data. (eg. <strong>A.xls</strong>)</li>
  <li>The Data on this excel file are on a single worksheet (Sheet 1).</li>
  <li>The number of columns in this file is fixed i.e. 8</li>
  <li>However, the number of rows containing data may vary from time to time. (This file is updated by another program from time to time)</li>
  <li>Now, I have another excel file (eg. <strong>B.xls</strong>) with similar type of data but not same as the contents of <strong>A.xls</strong>.</li>
  <li>The number of columns in <strong>B.xls</strong> is 8 as well. However, the number of rows containing data are unknown.</li>
  </ol>
  
  <p>I want to copy the contents of <strong>A.xls</strong>, <strong>2nd row onwards</strong> (<strong>excluding the 1st row containing the column headers</strong>) and append/paste the same to the B.xls file, without over-writing the existing data on B.xls.</p>
  
  <p>With all these details in mind, I want to write a vbscript to automate this task.</p>
  
  <p>Please help.</p>
  
  <p>Thanks a lot, in advance.</p>