First of all I'm new to LibreOffice and i'm kind of a numbskull if it comes to the more advanced options within this software. What I'm trying to achieve is the following, I've got data consisting of "code" "date" "text" "value" which I keep journalizing. I want to manipulate this data in a different sheet in a manner that I want the whole rows parsed to the different sheet depending on which "code" and "date" I'm looking for. See the following picture: [IMG]http://i54.tinypic.com/20ubpdt.jpg[/IMG] I've been toying aroudn with DataPilot now for quite some time and I can sort nicely on "code" but I fail to parse entire rows like I want to. Anybody has a clue how to solve this? It seems like an easy problem but to keep the journal as it is it gets a bit complicated. (solutions like Sort don't work out in such case I think). -- View this message in context: http://nabble.documentfoundation.org/Calc-and-datapilot-tp2856239p2856239.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+help@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
