I recorded a macro that cuts and pastes a specific region from sheet 1 to sheet 4. How do I now specify the code to only perform that function if the word "published" is in that specific region. This is the macro I have so far
Also, how do I tell the macro to paste the information that has been cut under the data that was lasted pasted--rather than paste over the exisiting information.
Can someone lead me in the right direction?