Dynamically Update a Drop Down List

Hello, how do I do this with the list and the dropdown list located in different sheets?? Thank you

Originally Posted by sandy666

Change your list to Excel Table (Insert - Table)

edit: Ups, I overlooked - different

but you can find much more here: http://www.contextures.com/xlDataVal05.html

Thank you, that is not what I'm trying to do though, when I place the table in a different sheet (not different workbook) it does not update the dropdown list

Originally Posted by sandy666

Enough to little search there: http://www.contextures.com/xlDataVal...differentsheet

I am really grateful to you for trying to help me, I understand you can have a dropdown list and the table on a different sheet, I get that, but that way it does not work dynamically. My english is terrible so I'd try with an example

table: sheet 1
Consoles
Nintendo switch
PS4
Xbox one X

Dropdown list: sheet 2 ---} perfect!!

Now; I forgot to include PS4 pro and Xbox One S, I go to table on sheet 1 and add them, then go to sheet 2 and notice the dropdown list does not show these last two.

P.S: when the dropdown list and the table are on the same sheet it works!

you can try with OFFSET with the Name
http://www.contextures.com/xlNames01.html#Dynamic

.

Let's say your dynamic list is located in Col A (it can be any column).

- Highlight the total rows in Col A you believe may be used.

- Name that ..... MyList


Go to data validation, choose list and type =MyList

Now right click on the sheets tab and select view code and paste the following code:

Please Login or Register  to view this content.

This code will change the range of MyList whenever a change is made in column A.

Originally Posted by sandy666

you can try with OFFSET with the Name
http://www.contextures.com/xlNames01.html#Dynamic

Thank you everyone, this method works, let me try with the others you guys suggested, thank you so much for your patience... really

Originally Posted by sandy666

or
Create List
Insert Table
don't remove selection but go to Formulas - Defined Names - Create from Selection - Top row (I assume your list has header)
then go to tab where you want your DropDown, create DropDown - List - (F3) and select Name of your (just created) list

if you want update your list (and drop down) simply type under table new item and table "grab" this item automatically then it will appear in your drop down

don't use name of table, eg. Table1 and so on

is that what you want?

Perfect, exactly what I meant, I don't really understand why "create from selection" makes the difference but it works

Create from selection is easier (less clicks)

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.