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

A	B	C	D	E	F	G
1234	any	broken down	belfast	any	closed	1/1/18
3858	any	broken down	newyork	any	closed	2/2/18

<tbody>
</tbody>

 

[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