Cut and move rows to different worksheets
 

Hi everyone,
My problem is this; I have two worksheets (1 and 2) and on Sheet 1 I have
data about 'work in hand'. What I would like to do is when the work data on
any one row is marked as completed is simply hit a macro button that will cut
the entire row and paste it to Sheet 2 on the next available row/cell (A1, B1
etc), return the user to sheet 1 and then delet the (now) blank row. Any
ideas, please?