Calc - invoice -client list

Hello to everyone,
this is my first post on this forum, im neewbie in LibreOffice world. Recently i have move my office work completly on Linux from Windows.
Sice im running my small business start-up i need somehow to write my invoices. Before on Windows platform i had small software which i cant use anymore because company who maked software doesnt exist anymore ( software was clous based ).
Now i started to use LibreOffice Calk template ( Automated Multi-Invoice Collection » Extensions ).
Template works great even after few modifications which i maked ( company details, translation on German language etc ), but now i have little problem which i dont know how to solve ( i didnt use office tools since my high school ) and that is automated import client data from client list.

Inside of template i have added one more sheet called “client list” and i have filled 15 rows with “clients”, i have few columns for basic data ( client number, name, adress, post, town, country, phone, email ).

my idea is that start invoice template and choose “Invoice_easy_to_add” type of invoice and choose client by client number/name and that template autofill all another data automaticaly.

i googled good hour but i didnt found any practical solution. maybe i dont know how to google correct hints :frowning:

if someone can help me whit some idea/link/tutorial etc i would be really thankful.

cheers ,
Alex

Cross posted at Invoice and client list (View topic) • Apache OpenOffice Community Forum

If you cross post, please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.

Hi @acm_fabricates, Basic example

Test file