Moving a row that goes from Open to closed to a seperate sheet

[Oakey]

Hi,

Im looking for a Macro or code to use, that would automatically to move a row of data when a criteria goes from 'Open' to 'Closed'.

I want the data to move from one sheet to another sheet in the same workbook, but also want it to move down to the next row.

The information looks like this

Case n.

Date

Order n.

Reason

Location n.

No of Units

Comments

Status

Response needed by

<tbody>
</tbody>

30849329	06/11/2018	50005653811	over 45	18b	1	yellow jacket women	closed	21/11/2018	weronika
30850097	06/11/2018	50029456753	over45	6e	1	metallic sweater	closed	21/11/2018	zaneta
30849712	06/11/2018	50004567380	over 45	15a	1	dresses women	open	21/11/2018	weronika
30852539	06/11/2018	51434092740	two right shoes	7h	1	black shoes	closed	21/11/2018	zaneta
30854298	06/11/2018	51510481086	non Supplier item	30c	2	panties and socks	closed	21/11/2018	weronika
30853340	06/11/2018	51478430656	non Supplier item	fl1	1	supplier shorts	closed	21/11/2018	zaneta
30855055	06/11/2018	51470875598	wrong item	17a	1	yellow coat women	open	21/11/2018	weronika
30854314	06/11/2018	51492590672	missing plastic foil	33a	1	2x perfumes	closed	21/11/2018	zaneta
30855642	06/11/2018	51476947233	non Supplier item	18a	1	black blouse	open	21/11/2018	weronika
30854786	06/11/2018	50014629746	non Supplier item	fl1	1	tfhn london sequinn dress	closed	21/11/2018	zaneta

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>