VBA not working properly

Hi All, thanks for any help you can provide. I have been through and tested this code many times and cannot figure it out.

My goal here is to go through all of the rows. If column J = Promotable, copy that row to the Promotable tab. If J is Well Placed, move to the Well Placed tab.

It works great for the Promotables, then it stops and does not copy any Well Placed. The odd thing is I originally had this code reading Range("C1:C"...) and Value = "Community Mgr" and it worked great. When I changed the Range and Value, it crapped out on me.

Please Login or Register  to view this content.