title: Copy data to another selected sheet using Command Button
body: <p>Sir, I have a problem in excell.
  I have a file in excell consist of several sheet.
  In sheet "Student", there is a list name of students in range of cells (b2:b21) and also a list of their subject in range (d2:d5).</p>
  
  <p>In sheet "Form", there are form to input result of their test in range (D7:M7), a cell for name of student (D2) and a cell for their subject (D4). (D2) and (D4) is a drop down list and source from "Student" sheet.</p>
  
  <p>I also created several subject sheets</p>
  
  <p>I want to copy data from "Form" sheet range (D7:M7) to "Math" sheet or "Physic" sheet or etc range (C4:L23), depend on what is selected in cell (D2) and (D4).
  I also add activex control command button "Submit". So, when I klik "Submit" button, data in "Form" sheet range (D7:M7), copied to another sheet in range (C4:L23).
  I need vba code to program "Submit" command button in order to make the proces done.</p>