Ask Your Question

Split data into multiple worksheets

asked 2015-05-20 12:15:05 +0100

vyanix gravatar image

Does anyone know how I do something like this ( ) in libreoffice?

Can this be a suggestion to improve the libreoffice? and if the libreoffice could also save every worksheet to multiple files?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-05-20 12:29:14 +0100

karolus gravatar image

Its doable, but for what purpose???
→Data→Filter→Autofilter already exists - without producing many sheets of redunant Data.

edit flag offensive delete link more


Suppose you have a file in "csv", exported from a database from your website, and you need to distribute that data (separately by zones - in files ou worksheets) to your employees, to make contacts.

I know I can do this using filters: - filter zone 1, copy, create new sheet and paste them; - filter zone 2, copy, create new sheet and paste them; - iden, iden, iden ...

But it was better if I was able to convert the data of a particular column and split into worksheets or into files by prefix.

vyanix gravatar imagevyanix ( 2015-05-20 17:32:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-20 12:15:05 +0100

Seen: 2,333 times

Last updated: May 20 '15