VBA code

[sorin1985]

Hi guys

In the bellow excel , if I fill the row in Items received and then put a date in column P it will trigger and cut and move the entire row to sheet ITEMS Collected . I am using this code bellow the picture and everything works fine . What i would like is to have column K in Items Received as a trigger as well and cut and move everything to Remote Storage Unit . The trigger can be a number or text or what ever .

Is it possible to add another code to the same sheet1 in VBA ?

Hope it make sense .
Thank you

 

[sorin1985]

hi MART

Sorry i was blind . It is all good now . just a quick one ; at the moment it is trigger by date . Can you use a word or a number or anything else then date to trigger ?

You are a genius . Thank you

 

[mart37]

see #8

 

[sorin1985]

sorry ,what is #8 ? i have tried to search in here but nothing relevant appears .

 

[mart37]

#8 ==> post 8

If Not IsEmpty(Target) Then