Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days. If you want to solve this job in Excel worksheet, the Kutools for Excel’s Select Specific Cells can help you select the specific rows first, and then paste the rows to another sheet as you need. Here is another formula: =query(original!A:E, "where E = 'Complete' ",0) also can help you to finish this task.Ĭopy rows to another sheet based on specific cell value in Microsoft Excel In above formula: original!A:E is the sheet name and data range that you want to copy rows from, original!E:E="Complete" is the specific criteria, means to copy the rows that contain the word “Complete” in column E. To copy the rows based on specific text to another new sheet, the following formula may help you, please do as this:Įnter this formula: =filter(original!A:E,original!E:E="Complete") into the new sheet where you want to paste the specific rows, and then press Enter key, all rows which contain the specific text in column E have been pasted into this new sheet, see screenshot:ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!