Multiple Function issue

**sryan32** · 03-09-2010, 03:40 PM

I am fairly new to VBA and am having an issue that I cannot figure out. The first section of my code provides conditional formatting based on the items in the third columns drop down menu. This section of code is working fine. The second section of code is meant to take a row that has "completed" in the 3rd column, and copy the entire row and paste it to the second sheet "Completed". I have this code working in a seperate file, but when I try to combine the two functions I can't get it to work. Any thoughts? Thanks in advance for any help.

**JBeaucaire** · 03-09-2010, 03:48 PM

Try this, remove all the other code and replace with:

Please Login or Register  to view this content.

**sryan32** · 03-09-2010, 04:45 PM

Yes works perfectly. Thanks for your help.

**JBeaucaire** · 03-09-2010, 08:24 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

====
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)