Fermé

LibreOffice Calc link to Base Database file

I have a LibreOffice Calc file which I use for my invoices. From my website I have a export with my customer data (customer number, company name, customer name, adress, zip, city) which is also available in a Base Database.

What I want is the Calc file and the Base/csv database get connected with the following functionality:

- I want to select the customer number in a list-view in the calc-file (customers number from the base/csv).

- If I select that customer number the Company name, customer name, adress, zip and city field get filled in automatically according to the same row in the base/csv as the customer is in.

For example when in the base/csv are the values:

Customernumber, Company, Customer, Adress, Zip, City

JM-001, Building Company, A. de Boer, Homestreet 12, 1234AB, Eindhoven

JM-002, Construction Company, Z. de Vries, Nicelane 78, 9876ZX, Den Haag

In the drop-down in my calc file I select "JM-012". The Company name, customer name, adress, zip and city field get filled in to their fields to.

This should be a hard job. I think it is even possible without the use of any macro's.

Compétences : Excel

Voir plus : libreoffice calc database, libreoffice calc base, link calc base, link calc database, libreoffice link base calc, libreoffice calc link base data, libreoffice calc link base, libreoffice base export csv, libreoffice calc data base, libreoffice calc link database data, link calc base libreoffice, libreoffice base link, export database libreoffice, link base calc libreoffice, libreoffice link database, link base calc, libreoffice calc use base list, libreoffice calc data database, calc base, database libreoffice calc, link file libreoffice base, libreoffice link file, libreoffice base link calc, base libreoffice calc, link calc data fields

Concernant l'employeur :
( 0 commentaires ) Netherlands

N° du projet : #1625192

1 freelance fait une offre moyenne de $100 pour ce travail

ilhamhussain

i can do this work without using macro but using the conditions

200 $ USD en 5 jours
(0 Commentaires)
0.0
yuree777

I can do this work using VLOOKUP function. I can begin work in 14-th of May. B.R. Yuree.

100 $ USD en 2 jours
(0 Commentaires)
0.0