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.
Bookmarks