Smart Search in Excel

[deepakhp]

Hi,

I am trying to get excel to work like a webapp(eg: google search) where we can have smart search.
Problem Statement : I have a list of things in Sheet 1 (Eg: over 100 unique entries in a column, sheet 1 is like a database), which the user is currently using via a drop-down (scroll down and choose).
Require : Smart Search method so that use can for example input "A" where all entries/texts starting with "A" would be populated and make it easier for user to choose. This can also be in drop downs where use can input and drop down get updated based on input.

I am hoping we can do this in excel. If not, do i need to use some database tool for storing my database and then doing this via some scripting language?
Any help here would be appreciated.

-Deepak

 

[AD_Taylor]

Dear AD_Taylor,

The Skydrive folder that the link points to is emply. Would you be kind to post your example once more. I would really appreciate that. I looking for a solution that creates a filterable drop down list based on text value in Excel 7.
Thank you

Hi unity,

Thanks for getting in touch. I've migrated everything to a new account so that link will have stopped working. Please try this new one: http://sdrv.ms/1j37KgJ, and I've also updated the link in my signature.

As before it is the file named 'Filter Drop Downs from string' that you'll want, and make sure to right click and download it so that you get a copy you can easily work with.

If you have any other questions about the file, feel free to ask.

 

[unity]

Many thanks.

 

[unity]

Many thanks.

 

[ysl1848]

Hi Mr Ad_Taylor,

I Really admire you excel skill, Can you please help me for my assignment?

Actually I have the big table show below

[TABLE="width: 1151"]
<colgroup><col><col><col><col><col><col><col span="8"></colgroup><tbody>[TR]
[TD]No.[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD="colspan: 2"]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]xxx[/TD]
[TD]Remark[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]xx[/TD]
[TD]xx[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD]A-PC[/TD]
[TD]a[/TD]
[TD]m[/TD]
[TD]aa[/TD]
[TD]an[/TD]
[TD]bb[/TD]
[TD]bc[/TD]
[TD]bd[/TD]
[TD]be[/TD]
[TD]bf[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A-SC1[/TD]
[TD]b[/TD]
[TD]n[/TD]
[TD]ab[/TD]
[TD]ao[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A-SC2[/TD]
[TD]c[/TD]
[TD]o[/TD]
[TD]ac[/TD]
[TD]ap[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A-SC3[/TD]
[TD]c[/TD]
[TD]p[/TD]
[TD]ad[/TD]
[TD]aq[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]q[/TD]
[TD]ae[/TD]
[TD]ar[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]B-PC[/TD]
[TD]e[/TD]
[TD]r[/TD]
[TD]af[/TD]
[TD]as[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]B-SC1[/TD]
[TD]f[/TD]
[TD]s[/TD]
[TD]ag[/TD]
[TD]at[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]B-SC2[/TD]
[TD]g[/TD]
[TD]t[/TD]
[TD]ah[/TD]
[TD]au[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]B-SC3[/TD]
[TD]h[/TD]
[TD]u[/TD]
[TD]ai[/TD]
[TD]av[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]C-PC[/TD]
[TD]i[/TD]
[TD]v[/TD]
[TD]aj[/TD]
[TD]aw[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]C-SC1[/TD]
[TD]j[/TD]
[TD]w[/TD]
[TD]ak[/TD]
[TD]ax[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]C-SC2[/TD]
[TD]k[/TD]
[TD]y[/TD]
[TD]al[/TD]
[TD]ay[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]C-SC3[/TD]
[TD]l[/TD]
[TD]z[/TD]
[TD]am[/TD]
[TD]az[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ba[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
where a - bf is a complete formula for the a model ( a+b+c.....+bf=1 model). In each category will have a lot of source.
what I need to do is create the dropdown list for a - bf, then create the table for each category in other sheets. But it is necessary to add the new value from the dropdownlists instead of add on the table. Then when finish key in the table, I will click the "confirm" button. Then the first think will do is check it is duplicated formulas for the complete table. If Yes Should message box to indicate which number already have the formulas, and if No it will create the new table continuously