Need HELP with code auto move whole row to new worksheet based on data

[crazydoglady]

hi i could really use some help. i have two work sheets outstanding and and i want to be able to automatically hide an entire row based on the text "closed" from my outstanding worksheet and move it to completed.
i know this cant be done with a function or formula and my knowledge of code is awful.
Can someone please help?
my closed column is a drop down not sure if it makes a difference and my rows start in A3

Outstanding
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]any[/TD]
[TD]broken down[/TD]
[TD]belfast[/TD]
[TD]any[/TD]
[TD]closed[/TD]
[TD]1/1/18[/TD]
[/TR]
[TR]
[TD]3858[/TD]
[TD]any[/TD]
[TD]broken down[/TD]
[TD]newyork[/TD]
[TD]any[/TD]
[TD]closed[/TD]
[TD]2/2/18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[crazydoglady]

You are very welcome.

Hi mumps you were helping me yesterday with my code issues. I wanted to move a sheet from outstanding to completed and you gave me a macro which worked brilliant and now today when in work I went
to use the spreadsheet for some reason its not working and I cant understand why, do you have any clues I think it is excel 2016 I am using

 

[mumps]

I really don't know why it wouldn't be working now. Can you post a copy of the file that is now not working? Please see Post #6 for instructions.

 

[crazydoglady]

I really don't know why it wouldn't be working now. Can you post a copy of the file that is now not working? Please see Post #6 for instructions.

Hi thanks for replying again, I think it could be to do with our company server. I need to speak to IT cause it works perfect on my home PC

 

[mumps]

In order for the macro to work, you have to enable the macros in Excel. Quite often, for security reasons, some organizations will leave them disabled.

 

[crazydoglady]

In order for the macro to work, you have to enable the macros in Excel. Quite often, for security reasons, some organizations will leave them disabled.

yes that's what i thought i will check it out tomorrow. i know its not recommended to have macros enabled. thanks again