Help with Excel if function and macros

  • Thread starter Thread starter perl
  • Start date Start date
P

perl

Hi everyone,

I"m currently working on an excel file for shipping. I created a macro which
automatically makes a line jump onto a worksheet called "shipped orders" once
the status of the line is "shipped". Now I would like to add an if function
that if Cell N1 contains a ups shipping# the status should change to
"shipped". the function worked however for some reason the line did not jump.
Any Solution? I would be grateful if anyone could help.

Kind Regards,

Perl
 
Hi,

I'm not sure what your refering to. do you want me to repost my question
under general comments?
 
sorry gottcha

my code is:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If UCase(Trim(Target.Value)) = "SHIPPED" Then
Application.EnableEvents = False
Target.EntireRow.Copy _
Worksheets("Shipped Orders").Cells(Rows.Count, 1).End(xlUp)(2).EntireRow
Target.EntireRow.Delete
Application.EnableEvents = True
End If

End Sub

thanks in advance,

Perl
 
Back
Top