Hope someone can help with this:
I have a list of vendor information and a purchase order spreadsheet. Would I would like to be able to do is in the vendor name field, when someone begins typing the name of the vendor, it will look in the vendor information sheet and autofill if it matches. If not the person continues to type the info.
If it does match and it is correct, hit enter and then the address information and contact info, etc will fill in their respective fields. If there isn't a match, the person will need to fill out all of the information manually, but once completed, it adds the information to the end of the vendor information sheet.
I know this is more of an access database sort of thing, but unfortunately, our company PO request is in excel, but I'd like to add a bit more functionality to it. If anyone can help, it would be greatly appreciated.
I have a list of vendor information and a purchase order spreadsheet. Would I would like to be able to do is in the vendor name field, when someone begins typing the name of the vendor, it will look in the vendor information sheet and autofill if it matches. If not the person continues to type the info.
If it does match and it is correct, hit enter and then the address information and contact info, etc will fill in their respective fields. If there isn't a match, the person will need to fill out all of the information manually, but once completed, it adds the information to the end of the vendor information sheet.
I know this is more of an access database sort of thing, but unfortunately, our company PO request is in excel, but I'd like to add a bit more functionality to it. If anyone can help, it would be greatly appreciated.
