Copy filtered rows

achintha

New Member
Joined
Jul 19, 2010
Messages
4
Hi,

I got a spreadsheet with following details

name, address, city, postcode, phone and email

I would like to get rows that email filed is blank into separate spreadsheet, so I can send them a letter.

How can I get just these rows?

thanks a lot for your help
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Here's one way:

1. Copy the whole sheet.

2. On the new copied sheet, select the email column by clicking its heading label.

3. Apply AutoFilter to the column.

4. Use the AutoFilter to filter to Non-Blanks

5. Select all the visible rows and delete them.

6. Remove the AutoFilter.

If you need more help, please provide more details and which Excel version you are using.
 

achintha

New Member
Joined
Jul 19, 2010
Messages
4
it worked thanks :)

Here's one way:

1. Copy the whole sheet.

2. On the new copied sheet, select the email column by clicking its heading label.

3. Apply AutoFilter to the column.

4. Use the AutoFilter to filter to Non-Blanks

5. Select all the visible rows and delete them.

6. Remove the AutoFilter.

If you need more help, please provide more details and which Excel version you are using.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,893
Messages
5,598,712
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top