General discussion

Locked

create new spreadsheet using data in ex

By hazion ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

create new spreadsheet using data in ex

by DKlippert In reply to create new spreadsheet us ...

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.

Collapse -

create new spreadsheet using data in ex

by hazion In reply to create new spreadsheet us ...

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

Thanks again,
Kathy

Collapse -

create new spreadsheet using data in ex

by hazion In reply to create new spreadsheet us ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums