title: create a Command Button to copy and paste data in another sheet
body: <p>I am using the code below (found on the intrnet) to copy and paste a row when a button is clicked in Excel.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
      Application.ScreenUpdating = False
      Dim xSheet As Worksheet
      For Each xSheet In ThisWorkbook.Worksheets
          If xSheet.Name &lt;&gt; "Definitions" And xSheet.Name &lt;&gt; "fx" And xSheet.Name &lt;&gt; "Needs" Then
              xSheet.Range("A1:C17 ").Copy
              xSheet.Range("J1:L17").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
          End If
      Next
      Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>How can i modify this code to copy the data from sheet named "input" to another sheet named "list" ?</p>
  
  <p>Also, how can I ship a row everytime the SUBMIT button is pressed? </p>
  
  <p>And one last question; one of the cells includes a =NOW() function. When using the code above to copy and paste the data, this cell is showing garbage data. How can I prevent this from happening? </p>