I'm more and more convinced that for a dynamic solution Base is the answer so today I started fiddling a bit. The journal I saved, started Base > connect to an existing database > spreadsheet > select file > finish Then select on the left below Database Queries, create Query in Design View where for now I selected all columns I want. I got to see then basically the whole journal I saved and ended the program. Started Calc, saved a blanc file. Tools > LibreOffice Base > New, select the just saved DB where it will show up then as a Registered database. Press F4 where you get to see the present databases where the selected database also is visible (created Query in Base as well the Table it self). Next will be how to make a query that basically consists of making a selection based upton "code" and "boekdatum". Slowly progress! -- View this message in context: http://nabble.documentfoundation.org/Spreadsheet-and-datapilot-tp2856239p2871544.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