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. Also, is there a way to automate it so that, say with a click of a button the filtering takes place? -- View this message in context: http://nabble.documentfoundation.org/Automate-a-Data-Filter-in-Calc-tp3847162p3847162.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org 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