Excel 2010 If statement to move entire line to another worksheet

[Justineoutland]

I use excel 2010 for a work order worksheet. One the work order is complete ( the work complete in say J3) I want to move that entire line to worksheet 1 (from work orders). So if J3 says "complete" then move entire line to worksheet 1. Please help. Thank you, Justine

 

[DSCfromCFA]

G'day Justine,

An IF formula is not going to do what you want, as it cannot work with entire rows.

I would suggest that you need a VBA solution and if this bump doesn't elicit any responses, you may need to re-submit your question asking specifically for a VBA solution.


Good luck

shane