Hi Guys,
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
Code
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?