|You have not answered my question. Let me try again.|
There are (at least) 2 options for copying the row when Mike "appears in cell J5".
1 - There are event macros that can copy the row as soon as the user types "Mike" into J5. As soon as the user moves away from the cell either by hitting enter, using the arrow keys or clicking with the mouse, the code will check to see if the cell contains Mike. If it does, the code will copy the desired range.
2 - There are "manual" macros which you can run that will start in Row 1 and check each cell in Column J to see what it contains. Each time it finds "Mike", it will copy that row and then continue checking the column until it reaches the bottom of the data.
I am asking you to tell us which method you want to use: The immediate method that happens each and every time Mike is entered into Column J or the "one time" method that scans the existing data in Column J and copies the ranges whenever Mike is found.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.