Trigger Code by Dropdown

Hey everyone,

I have a VBA Code which moves the entire row to the second worksheet if it contains the word "Closed" in column A. I was wondering if someone could help me make the code refer to a drop down list which I will create. For some reason, when I create the drop down list for Column A, the code no longer works. Below is the code.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Thanks!