Live table extraction

Discuss the spreadsheet application
Locked
User avatar
JLeite
Posts: 31
Joined: Mon Jan 03, 2011 2:12 am
Location: Porto, Portugal

Live table extraction

Post by JLeite »

Greetings.
I have a table with Covid-19 data which grows one line/country/day, see attachment.
My purpose is to extract all the lines from several countries, for instance Portugal, USA and Germany, to another sheet without going through the process of searching the lines I want.
I need the data to go to a dedicated sheet which is named after the country.
I need it to happen automatically. In destination sheet the data should always start on line 2.
Is there a way to achieve such thing?
Thank you for your help.
JLeite

http://www.mediafire.com/file/3ranz9o6s ... 9.ods/file
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-6ubuntu2~10.04.1
User avatar
robleyd
Moderator
Posts: 5383
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Live table extraction

Post by robleyd »

Cross posted to AskLibreOffice where responses have been made.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 25.2.31.2; SlackBuild for 25.2.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue]
Unexpected '{' on line 32
.
Locked