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

[TABLE="width: 2039"]
<tbody>[TR]
[TD="class: xl63, width: 194"]Case n. [/TD]
[TD="class: xl65, width: 83"]Date[/TD]
[TD="class: xl63, width: 142"]Order n. [/TD]
[TD="class: xl64, width: 530"]Reason [/TD]
[TD="class: xl65, width: 172"]Location n. [/TD]
[TD="class: xl65, width: 130"]No of Units[/TD]
[TD="class: xl64, width: 593"]Comments[/TD]
[TD="class: xl65, width: 57"]Status[/TD]
[TD="class: xl66, width: 138"]Response needed by[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 2152"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]30849329[/TD]
[TD]06/11/2018[/TD]
[TD]50005653811[/TD]
[TD]over 45[/TD]
[TD]18b[/TD]
[TD]1[/TD]
[TD]yellow jacket women[/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]weronika[/TD]
[/TR]
[TR]
[TD]30850097[/TD]
[TD]06/11/2018[/TD]
[TD]50029456753[/TD]
[TD]over45[/TD]
[TD]6e[/TD]
[TD]1[/TD]
[TD]metallic sweater[/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]zaneta[/TD]
[/TR]
[TR]
[TD]30849712[/TD]
[TD]06/11/2018[/TD]
[TD]50004567380[/TD]
[TD]over 45[/TD]
[TD]15a[/TD]
[TD]1[/TD]
[TD]dresses women[/TD]
[TD]open[/TD]
[TD]21/11/2018[/TD]
[TD]weronika[/TD]
[/TR]
[TR]
[TD]30852539[/TD]
[TD]06/11/2018[/TD]
[TD]51434092740[/TD]
[TD]two right shoes[/TD]
[TD]7h[/TD]
[TD]1[/TD]
[TD]black shoes [/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]zaneta[/TD]
[/TR]
[TR]
[TD]30854298[/TD]
[TD]06/11/2018[/TD]
[TD]51510481086[/TD]
[TD]non Supplier item[/TD]
[TD]30c[/TD]
[TD]2[/TD]
[TD]panties and socks[/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]weronika[/TD]
[/TR]
[TR]
[TD]30853340[/TD]
[TD]06/11/2018[/TD]
[TD]51478430656[/TD]
[TD]non Supplier item[/TD]
[TD]fl1[/TD]
[TD]1[/TD]
[TD]supplier shorts[/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]zaneta[/TD]
[/TR]
[TR]
[TD]30855055[/TD]
[TD]06/11/2018[/TD]
[TD]51470875598[/TD]
[TD]wrong item[/TD]
[TD]17a[/TD]
[TD]1[/TD]
[TD]yellow coat women[/TD]
[TD]open[/TD]
[TD]21/11/2018[/TD]
[TD]weronika[/TD]
[/TR]
[TR]
[TD]30854314[/TD]
[TD]06/11/2018[/TD]
[TD]51492590672[/TD]
[TD]missing plastic foil[/TD]
[TD]33a[/TD]
[TD]1[/TD]
[TD]2x perfumes [/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]zaneta[/TD]
[/TR]
[TR]
[TD]30855642[/TD]
[TD]06/11/2018[/TD]
[TD]51476947233[/TD]
[TD]non Supplier item[/TD]
[TD]18a[/TD]
[TD]1[/TD]
[TD]black blouse[/TD]
[TD]open[/TD]
[TD]21/11/2018[/TD]
[TD]weronika[/TD]
[/TR]
[TR]
[TD]30854786[/TD]
[TD]06/11/2018[/TD]
[TD]50014629746[/TD]
[TD]non Supplier item


[/TD]
[TD]fl1[/TD]
[TD]1[/TD]
[TD]tfhn london sequinn dress[/TD]
[TD]closed[/TD]
[TD]21/11/2018[/TD]
[TD]zaneta[/TD]
[/TR]
</tbody>[/TABLE]