Am 22.03.2012 00:32, lagagnon wrote:
I have a 2500 line "database" in LO Calc with 10 fields per record (line). In a second sheet I want only specific records from the first sheet (the database) which match 3 criteria. I haven't quite figured out how to do that manually with Data, Filter, Standard Filter but it seems possible, but I cannot figure out how to post that filtered data to the second sheet.
Under [More Options] you can specify OtherSheet.A1 as target.
Also, is there a way to automate it so that, say with a click of a button the filtering takes place?
Click a single cell in the source range and call Data>Refresh This reapplies the last filter and/or sort order. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
