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
Range("B4:E11").Select Selection.Cut Sheets("2011 Publised Workflow").Select Range("B4").Select ActiveSheet.Paste Columns("B:B").EntireColumn.AutoFit Sheets("Upcoming Workflow").Select Selection.Delete Shift:=xlUp End Sub
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?