| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
Evening! I have a spreadsheet that in Column N I've created a list of data
entry options. This information pulls to Column C by a drop down menu via data vaidation format. There are 500 potential data entry choices, all alphabetized. Because of the volume of potential data, I'd like to make it keystroke sensitive so that if a "P" is the first letter entered in Column C, the drop down menu jumps down further to show the available "P" options. Thus eliminating the need for the user to scroll through the first couple of hundred options. Is this possible? I have no experience in macros, sorry. Thanks in advance. -- Sam |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation
A couple of suggestions:
http://help.wugnet.com/office/Data-V...ict991745.html -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "SamIAm" wrote: Evening! I have a spreadsheet that in Column N I've created a list of data entry options. This information pulls to Column C by a drop down menu via data vaidation format. There are 500 potential data entry choices, all alphabetized. Because of the volume of potential data, I'd like to make it keystroke sensitive so that if a "P" is the first letter entered in Column C, the drop down menu jumps down further to show the available "P" options. Thus eliminating the need for the user to scroll through the first couple of hundred options. Is this possible? I have no experience in macros, sorry. Thanks in advance. -- Sam |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation
Found one there that worked! Many thanks!
-- Sam "Wigi" wrote: A couple of suggestions: http://help.wugnet.com/office/Data-V...ict991745.html -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "SamIAm" wrote: Evening! I have a spreadsheet that in Column N I've created a list of data entry options. This information pulls to Column C by a drop down menu via data vaidation format. There are 500 potential data entry choices, all alphabetized. Because of the volume of potential data, I'd like to make it keystroke sensitive so that if a "P" is the first letter entered in Column C, the drop down menu jumps down further to show the available "P" options. Thus eliminating the need for the user to scroll through the first couple of hundred options. Is this possible? I have no experience in macros, sorry. Thanks in advance. -- Sam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Refresh existing data when changed in data validation list | New Users to Excel | |||
Linear Mode
