Hi DakotaNJ,
here's a trivial example which looks at the value in A1 on Sheet1 and
if it is greater than 10 places that value into A1 on Sheet2, otherwise
the value in A1 on Sheet2 is not changed.

Public Sub paste_If()
If Sheet1.Cells(1, 1) 10 Then
Sheet2.Cells(1, 1).Value = Sheet1.Cells(1, 1)
End If
End Sub

When trying out code make sure you have a back up copy of the workbook.
The effects of code are NOT undo-able.

Ken Johnson