06-19-2020 03:55 AM
Set up a list of words in a column on a separate sheet.
Then place the cursor on the cell that you want to create your drop down - and select Data Validation from the Data menu.
On the ALLOW option select LIST.
In the source select the range where your words are.
That is a basic method.
There are other things you can do to make it slicker but try that first.
06-19-2020 07:34 AM
07-13-2020 06:47 PM
I'm attaching a method of what I called "cascading" drop down or data validation lists. This simple demo is just based on first and last names....you can add combinations of first and last names to test the process. When you do, you'll notice that
This method makes use of the new Dynamic Array functions, UNIQUE, FILTER in particular. I also employ SORT so that the lists are shown in alphabetical order. But if you don't have the most recent version of Excel, you will not be able to use those functions, and therefore this method will not work.