Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu - Populate a list of matching words.
Hi,
Is there anyway that we can get the Detection to flag partial name matches in a populate list of matching words? I have an example here. At cell B6, if I enter the wordings "Flower Database", the cell should populate a list of matching words (John Database, Suzy Database, JH Datebase Ptd) from its column B, to alert me that there are a list of matching words and give me a dialog notes on whether to continue entering the wordings "Flower Database". This detection needs to work at each cell in Column B. For example: Column B Row 1 John Database Row 2 Suzy Database Row 3 JH Datebase Ptd Row 4 Happy Shoes Ltd Row 5 Happy Suzy Shoes Inc Row 6 -- Thank you, Cpviv |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu - Populate a list of matching words.
Try Debra's page for the "AutoComplete" featu
http://www.contextures.com/xlDataVal10.html -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "Cpviv" wrote: Is there anyway that we can get the Detection to flag partial name matches in a populate list of matching words? I have an example here. At cell B6, if I enter the wordings "Flower Database", the cell should populate a list of matching words (John Database, Suzy Database, JH Datebase Ptd) from its column B, to alert me that there are a list of matching words and give me a dialog notes on whether to continue entering the wordings "Flower Database". This detection needs to work at each cell in Column B. For example: Column B Row 1 John Database Row 2 Suzy Database Row 3 JH Datebase Ptd Row 4 Happy Shoes Ltd Row 5 Happy Suzy Shoes Inc |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu - Populate a list of matching words.
Thanks Max.
This "AutoComplete" feature doesn't work for me. There are two criterias that I need he (1) I need the matching data come from the same sheet 1 column B, and I can't possibly update the data validation list at a new sheet 2 as and when there is a new entry in sheet 1. (2) I need something smiliar to an example from this website (http://www.cathaypacific.com/cpa/en_SG/homepage). When I type 'Au' at the To field at the Book Flights tab, it will shows me a list of matching words to 'Au'. Is there anyway that I work with? -- Thank you, Cpviv "Max" wrote: Try Debra's page for the "AutoComplete" featu http://www.contextures.com/xlDataVal10.html -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "Cpviv" wrote: Is there anyway that we can get the Detection to flag partial name matches in a populate list of matching words? I have an example here. At cell B6, if I enter the wordings "Flower Database", the cell should populate a list of matching words (John Database, Suzy Database, JH Datebase Ptd) from its column B, to alert me that there are a list of matching words and give me a dialog notes on whether to continue entering the wordings "Flower Database". This detection needs to work at each cell in Column B. For example: Column B Row 1 John Database Row 2 Suzy Database Row 3 JH Datebase Ptd Row 4 Happy Shoes Ltd Row 5 Happy Suzy Shoes Inc |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu - Populate a list of matching words.
I'm out, sorry. Maybe other responders would offer you their views,
-- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |