On 27/04/11 18:18, Cor Nouws wrote:
Hi,
JZ1982 wrote (23-04-11 23:43)
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.
Getting the result as on the right side of your picture, can easily be
done with the default filter.
Data > Filter > Default
Then filter on code 402 and copy/paste the result to a different place,
when needed.
Hmm, but is it this what you want to achieve?
Kind regards,
Cor
Hi,
I don't think you can use Calc in the way you invision.
Some options exist...
1. Create a macro that sorts the list. This is not dynamic.
2. Create a duplicate of the sheet containing the core data. Use VLOOKUP
to dynamically duplicate the sheet. Then create a filter on each
duplicate sheet. Each duplicate sheet is filtered based on a particular
'volgnummer'. Usually I put this value at the top of the file as a
header. This works really well with small to medium datsets but can be
slow with larger datasets.
3. For larger datasets consider storing in a database then use Base to
import just the 'code' lines you want to each sheet. This is a bit more
complicated and less portable, depending on the database used.
--
Cheers Simon
Simon Cropper
Principal Consultant
Botanicus Australia Pty Ltd
PO Box 160, Sunshine, VIC
W: www.botanicusaustralia.com.au
--
Unsubscribe instructions: E-mail to [email protected]
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
