greekboy_uk
New Member
- Joined
- Nov 20, 2009
- Messages
- 19
Hello to all, I am a new user here so if I haven't provided enough info please let me know. Work: I have created a large database with companies names -suppliers numbers, vat rate-percentage, and cost code-description. The data is located at the same spreatsheet but in different workbooks. The first workbook is a workbook that my employees are going to use. The fields that includes are: Company, supplier no, vat, location, description,invoice no, invoice date, invoice received, net, gross, comments. When an employee types the comany's name that automatically brings up the supplier number, and the vat percentage. The only problem is that beacause there are thousands of comanies if the employee types a wrong letter it won't allow to enter it unless is the excact name as the one that I have created on the database. Help: What I would like to do is when the employee start typing the company's name e.g Orange Commuinications Plc. after it type the first few letters the drop down menu to start appearing with suggestions which helps the employee to choose it and also prvent them to make mistakes. When for example I have inserted a companys name when I type below it the same name excel automatically shows the possibility of the name which is good as well but that doesn't help if I haven't inserted that comany on the list. Also after the employee has entered the date of the invoice automaticaly the invoice received field to autofil the date that the user is inputing the data.e.g if the invoice date was 11/11/09 and the user put it on the spreadsheet on the 20/11/09 that field to autofill the 20/11/09 and if it was the 21/11/09 to autofil that date. Formulas: The fomulas that i have used are as follows: Supplier's number =IF($A3="","",VLOOKUP($A3,SUPPLIER!A$2:B$921,2,0)) Vat =IF($A3="","",VLOOKUP($A3,VAT!A$2:B$921,2,0)) Description =IF($D3="","",VLOOKUP($D3,VAT!D$2:E$25,2,0)) Gross =IF($A6="","",J6*C6+J6) I would like to thank you for taking the time to read my request and if there is someone that is able to help I it would be much appriciated. thanks a lot