Going to bump this as I'm still having no luck getting a macro to do what I want it to do. I've gotten it to copy, paste to desired ws, and clear, however, I've only been able to make this work with a set range and not the user selection(s).