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
Live table extraction
Live table extraction
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-6ubuntu2~10.04.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-6ubuntu2~10.04.1
Re: Live table extraction
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
---------------------
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
.