A few weeks ago, a coworker had the task of splitting a long spreadsheet table of people into several smaller files, one for each country. Doing it manually is tedious work: sort the rows by country, create a new file for each country, copy the headers into each target file, copy the appropriate row range. Whenever the table changes, repeat it all over. Tedious work on computer data is asking for automation, so I built a LibreOffice macro.
(mehr …)