Đã Đóng

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.

Kỹ năng: Excel

Xem thêm: libreoffice calc database, libreoffice calc base, link calc base, link calc database, libreoffice link base calc, libreoffice calc link base, libreoffice base export csv, libreoffice calc data base, link calc base libreoffice, libreoffice base link, export database libreoffice, link base calc libreoffice, libreoffice link database, link base calc, 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, data den, libreoffice calc database link, libreoffice base calc

Về Bên Thuê:
( 0 nhận xét ) Netherlands

Mã Dự Án: #1625192

1 freelancer đang chào giá trung bình $100 cho công việc này

ilhamhussain

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

$200 USD trong 5 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
0.0