Moved Row to Another Sheet on Conditional Format

[jojithedevil]

Hi i have a car inventory which has 3 sheets

1. New Car Inventory | 2. Incoming Inventory | 3. Sold


I have a column in Incoming Inventory (SHEET Num# 2) titled Sold (SHEET Num#3) (Column U) which has cell fields IN and OUT.

What i want is if the cell in the Incoming Inventory (SHEET Num# 2) says IN then the whole row should move to New Car Inventory (SHEET Num#1)

and

if in New Car Inventory (SHEET Num#1) the cell value is changed to OUT then it should move out in Sold (SHEET Num#3)

Please see the attachment

PS. Sheets have names i.e. Numbers 1,2,3 are giving just to make it easy to understand.

Thanks i will be very thankful! You guys have been awesome!

[mahaveersomani]

check the above code.....

If it was helpful to you then dont forget to hit the * button for user reputation....
Regards
CA Mahaveer Somani

[jojithedevil]

@mahaveersomani,

Hi there mate, thanks alot for the help but can you tell me where to paste this code! I am an excel noob so sorry for that!

[jojithedevil]

See guys here is the sample file.

If anyone can help me out i will be very thankful. I need it done please help me out!

[jojithedevil]

*BUMP* anyone please can help me?