Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto-complete from a drop down list and from a different workbook
I have thousands of suppliers. I don't want my employees to have
access to all of the suppliers' information. Just want them to have access to name, number, email. I have set it up so that when the employee types the name of the supplier into a cell, the row automatically fills in the number and email. However, the supplier's name must be typed into the cell EXACTLY as it is entered into the master supplier list, which is in a different workbook which my employees don't have access to. Is there a way to start entering the name of the supplier, and after 1, 2, or 3 letters are entered, Excel automatically refers to the suppliers list and completes the entry, or gives 2 or 3 choices so the employee can just click on the name and it will be entered into their list exactly as in the master list? I know this is wordy, but I don't know how else to describe. Please, any help is very much appreciated. Thanks.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Complete a select from a data validation list | Excel Discussion (Misc queries) | |||
auto complete in list | Excel Discussion (Misc queries) | |||
Auto complete in a validation list | Excel Discussion (Misc queries) | |||
Auto-complete an entry in drop-down list | New Users to Excel | |||
Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) |