How to Create Drop Down Lists in Cells - The Complete Excel Guide

Jon you are a genius an a generous soul. Thank you so much for sharing your hard work! It is very useful.

I do not find XL campus in excel 2007?

thank you sir,, very helpfu....

It really helps, thank you very much.

I have positive or negative number against each year. All positive numbers are tax credit which can be utilised for next 15 years. All negatives are utilisations which can be adjusted from available credit for that year.
After 15 years, balance will lapse and not available to be adjusted by any negative number.
How can this be achieved in excel?

nice search add-ins but the problem is, if you want to search for name for example the family name will not change and others col so in this case this will make the table wrong .thank

Nice utility, well designed.

Thank you sir. Very helpful.

brilliant solution. exactly what i need. thank you.

Thanks

Amazing Tools! Thank you very much for your job. Subscribed!

What is the limit of rows?

Thank you so much for sharing your hard work! It is very useful.

tell me the shortkey to get access directly without using mouse

May God shower all his blessings on you dear John.

Resp sir,i have learnt a lot from your valuable videos. thanks. further, in a data validation list if we give the source from name manager and if we type any thing other than the entries of the dropdown list in the dropdown cell, no error message comes. why? secondly if we want to give the source from another sheet to a drop down list, we can't do that. why? pl help



Thank you sir for providing just a useful tool.

Is there a way to disable the Validation Error? In a regular data validation list I can turn off the error if I type in something that is not actually on the list. This way I can use my list but also type in any other item that may be needed. I've disabled the error that Excel pops up, but the one from the Add-In still comes up.

Thanx thanks again sir i am so happy today.. i am lot of video see for searchable drop down list.. thanks i am download this

Thanks ... Thanks .

Could you also give example for Open office spreadsheet

This is perfect! I set up the add in and tried it out in 5 mins.

Hello sir,
It's a very good option but how to keep it always in the workbook. If it is possible to keep there it would be a great HELP.

good

Thanks for the LIFE SAVER ADD-INS

Everytime I close the program, the Ec search list disappears and I have to upload it over and over again

Hye sir, can I get a guidance video on searching document to view in excel by using drop box list?

Hi, I was looking for just that, but I needed it without having to add this new tab and make it work directly on a series of validation data on a column. Where could I find the vba code? Thank you

Nice, but I cannot do this on my "work" computer. :( I do not have admin privilege for install options.

Hi there can anyone help me... ? I have excel data and have applied filtered to it.. and i want to add information to each item i. the list of filtered data. Now As list is long and I am selecting each item one by one by scrolling down. Is there any way to skip to next item in the list instead of scrolling from mouse as my list is very big and i have to go very down to select next value

Thank you Sir you save my day

How can I get more than one searchable list of menu

Wonderful add in - so much easier than ANY other method I've come across. Thank you.

Awesome! Thanks so much :)

Addin not sended to gmail

Where can I find the XL campus😭

But how it's work, I mean how to use it? In my Excel sheet

Excellent!!!!

I have a question I do not know how to solve.
I looked up several of your tutarials and I know how searchable dropdownlists work in 365 and older versions.
But this is something I do not know how to address or solve.

Situation:
I have a data set set with 3 different columns of data.
1. Team name
2. Function name
3. Employee name

From 1 to 2 and from 2 to 3 the relation is: one to many
So every team has several same functions and every function has several same employee names.
Is there a way I can set this up so I get the following result.
a) In the first dropdownlist-selection-cel: Choose a (part of a) team (T) => result: all the functions that appear in team T are presented in the second searchable dropdownlist.
b) In the second dropdownlist-selection-cel: Choose a (part of a) function (F) => result: all the employeenames that appear in team T with function F are presented in the third searchable dropdownlist.
c) In the third dropdownlist-selection-cel: Choose (a part of) an employeename (N) => result: all the employees with that name are presented in the third searchable dropdownlist where I can make the final choice.
Result is that I have three adjacent cells with “company name”, “function name” and employee name”.

The purpose of this allis the following.
In my company managfers have to fill a form with which they aplly for more formation in their team.
We cannot provide them ourselves with new places.
They have to be added in de database by the database administration.
The database administration has standard forms with which we have to apply for adding data to the database.
This form has to provide them with a lot of information.
All the other information we can distrackt from our own database, but to be able to do so, we need the three datdatypes I named above: team name, function name and employee name.
So if I know how to set this up, I also can do that fo a database with more then 3 different datatypes (columns).

Hope someone can help me with this.

Great add-in, but why doesn't works when the drop list is loaded from INDIRECT function cell? thanks!

can i run the add in through a macro assigned to a button ?

thanks it is really helpful

THX SO MUCH BRAVOOOO!!!!

Wow nice 👍 Sir

Jon
I was using this addin in excel 2021 - but after a recent update this addin
is stopped with a note "not trusted" i opened trust centre and upticked some
boxes but this addin remains obstructed.
ram

thanks

what version of excel you're using?