Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel if function and macros
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel if function and macros
As ALWAYS, post YOUR code for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "perl" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel if function and macros
Hi,
I'm not sure what your refering to. do you want me to repost my question under general comments? "Don Guillett" wrote: As ALWAYS, post YOUR code for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "perl" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel if function and macros
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 "Don Guillett" wrote: As ALWAYS, post YOUR code for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "perl" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros and sort function | Excel Worksheet Functions | |||
Macros in a cell function | Excel Worksheet Functions | |||
Sub list and rum macros in the function | New Users to Excel | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |