Hi,
i wish to create a sheet with my vendors.
How should it look like?
It should be two way data exchange form.
1. First one will be plain xls with collumns such as: Name, Surname, Adress, Phone, Email, UOM, Price, Currency etc. It is formula free, plain xls to be filled by vendor.
2. The second xls is "my front end" - formatted xls with ability to import these data from first xls (data connection), put them onto dedicated tab and import/add these data as a next row (one person per one row). On different tab there will be puchase order. I wish to be able to choose a vendor from drop-down list and when i choose one all the data from the data tab should be filled automatically.
Can You help me to produce something like this?
Thanks in advance!
i wish to create a sheet with my vendors.
How should it look like?
It should be two way data exchange form.
1. First one will be plain xls with collumns such as: Name, Surname, Adress, Phone, Email, UOM, Price, Currency etc. It is formula free, plain xls to be filled by vendor.
2. The second xls is "my front end" - formatted xls with ability to import these data from first xls (data connection), put them onto dedicated tab and import/add these data as a next row (one person per one row). On different tab there will be puchase order. I wish to be able to choose a vendor from drop-down list and when i choose one all the data from the data tab should be filled automatically.
Can You help me to produce something like this?
Thanks in advance!
