Software

Ask something
Discussion Locked

create new spreadsheet using data in ex

0 helpful
3 replies

by hazion

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I create a new spreadsheet using data in an existing spreadsheet? I need to select every 11th row of the original spreadsheet to create a new mailing list.
Thanks in advance.

3 replies

by dklippert

Someone will come up with a more elegant solution, but here's one way.
Create a new "Flag" column. Enter the formula:

=MOD(ROW(),11)

Double click on the tiny square in the lower right corner of the cell and it will duplicate it self to the last used row on the sheet.
Now go to Data>Auto filter. On the flag row drop the list down, choose Custom and choose equal 0.
This filters the list to display every 11th row.
Ctrl+G, or go to Edit>goto and choose special.
Select Visible cells only,copy and then paste to a new sheet.
This could also be done using an Advanced Filter to extract to another location.
Let me know if you need more help.

by hazion

Thanks!!
That worked perfectly, it's exactly what I wanted.

Thanks again,
Kathy

This discussion is closed to new replies.