Move Row to Another Sheet Based on Dropdown Value

Hello,

Thanks in advance for your help!

In the attached spreadsheet I am trying to figure out how to move a row from the "Active" worksheet to the "Completed" worksheet when the dropdown in column K is changed to complete. I have tried a couple examples on some forums but have not been able to get them to work.

Thanks Again!
Matt

Forgot to add. I'm assuming that the row will be cut and pasted to the new sheet. If that is the case I would like to delete the unused row from the original worksheet.

Hi Matt,
try this (in an "Active" worksheet module)

Please Login or Register  to view this content.

Would it be too much to ask for some advice on how to make this work. I am fairly new at this and I am not sure exactly where to put this code and how to execute it. Thanks for your patience with a newbie

here is your file
try to change the values in column K

You are a credit to humanity! Works great. Now I am going to make myself understand how it works.

Hi Nilem

this is exactly what I have been trying to do. I have tried to incorporate your code into my worksheet however keeps asking for a Macro name when I try and run it
Untitled.png

any ideas

thanks
Lizzy

Hi Lizzy,
this code is in a WorkSheet module and works automatically when a Worksheet_Change event occurs, so it does not appear in the list of macros.

nilem,

I noticed that when it copies from one sheet to another it does not appear to keep my data validation rules (dropdown list). Is there an easy solution for this or would it just be easier to eliminate the dropdown list? Thanks again for your help. I was able to duplicate what you did in the completed worksheet to send a row back to the active sheet. Now I'm just trying to break down the code line by line so that I understand the whole thing.

this is brilliant, thank you Nilem!!!

Hi Nilem,

What if you have multiple choices in drop down that you want the same thing to happen for each drop down to go to a differnt tab? Like initiated, in process, finalizing and complete?

Im trying to do the same thing - except when you choose the "Responsible Party" in column M it will move that row
to the sheet with that persons name on it.