Copy filtered rows

[achintha]

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

 

[Peter_SSs]

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]

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.