move rows

[keesie]

I am building a macro. The macro should move a row when the status in the row becomes 1 to a sheet called "1". When his status becomes 2, the row has to be moved to sheet called "2" and so on till sheet 5.

There is a overview sheet where the rows are filled with the information. All the rows should also stay in this sheet.

At this moment I have macro's that copy the selected row to sheet 1 to 5. But when the row has been in sheet 1 and copied to sheet 2, I can't get it deleted from sheet 1.

Can somebody tell me how to make this possible?

 

[unmarkedhelicopter]

I assume you enter your status number on the overview sheet ?
I assume there is a "key field" so we can identify which row to remove on say sheet 2 when it's status becomes 3 ?
I assume there is validation such that blank, 1, 2, 3, 4, 5 only are accepted ?
If yes and yes and yes then you could do it on the sheet change event and write some code to delete row off (number-1) and write line to (number)