I am looking for a macro that will read column D on my "Data Sheet" tab and depending on the text found copy and paste the entire row to the corresponding sheet in the workbook. As and example, if the phrase Not Covered is found in column D on Data Sheet, copy the entire row to the worksheet called "Not Covered". I'll need this to repeat for all rows on "Data Sheet" so I could end up with many rows of copied data on the "Not Covered" worksheet. I'll have the following phrases in column D on "Data Sheet" and corresponding worksheets, Not Covered, No Run, Not Completed, Blocked and Failed. I'll need "Data Sheet" reviewed for all of these phrases and the entire row copied and pasted into the corresponding worksheet with same name for all rows of data on "Data Sheet". Then I have two more specific requests for two additional tabs. Not Testable and Passed. Not Testable criteria is that in the text to be found in column D on data sheet is "N/A" and column E on "Data Sheet" is not empty. Then for Passed worksheet, the criteria is that column D on data sheet has the word Passed in it or has N/A in column D of data sheet and column E of data sheet is empty. So the last two phrases where I want to copy the full row from Data Sheet to the corresponding worksheet (Not Testable and Passed) have multiple criteria to be searched. Any help would be appreciated. I can create a macro on each individual sheet and run it so that it pulls from the Data Sheet and pastes into each individual worksheet, but that's a lot of clicking of the Run Macro button unnecessarily. I need a macro that will complete all searches in one run of the macro from the "Data Sheet" tab.