select rows with a certain value in a column

Thanks. Okay, getting close. The only thing is I want the new spreadsheet to have the entire row for the rows that have the value  selected.

To my knowledge, there is no standard technique in Excel to do that!

So we will use the VBA to accomplish this task!

• After you select the cells by using Find and Replace, keep them selected.
• Press Alt+F11 to open the VBA editor.
• Press Ctrl+G to view the immediate window as shown in the below screenshot:

• Copy this line of code to the immediate window: Selection.EntireRow.Select as below screenshot:

• In the immediate window keep the cursor in the first line and hit Enter.
• Close the VBA editor.

Now you have the entire rows with a specific value selected!

Click Ctrl+C to copy them, then paste them into another worksheet by Ctrl+V!

Simply, do the following:

• Highlight the column that you want, then click Ctrl+F as below screenshot:

• Type the value that you want to select it within the column, then click Options and check (Match entire cell contents) as below screenshot:

• Click Find All button, then Ctrl+A respectively!

• Close Find and Replace dialog box.

Now you have all the cells with a specific value selected!

Use the Data filter tool

The results can be copied to a new sheet

Click the Filter tool to remove the dropdowns

best wishes

Thanks. That does work but how can I create a second spreadsheet with only the rows with th e selected value ?

how about filtering the column?  then you can copy the filtered rows to another sheet.