Copy IF condition exists
Something like:
If Range("F5").Value<61 Then
'Your code to move/copy whatever you want.
End If
You will probably need more than that if you want to "move" the entire row
rather than just copy it.
HTH Otto
"Office_Novice" wrote in message
...
Is it possiable to Copy and paste if a specific condition exists?
Heres the problem in column "F" there is a number. If that number is less
then 61 i would like to move the entire row to another sheet. also the
range
will change with the data. can this be done?
|