-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
autofill from a list
- Thread starter HSOLDO
- Start date
Tinbendr
Well-known Member
- Joined
- Jul 21, 2010
- Messages
- 997
Data validation.
Give your list a name. (If the list is static, select list, then in Namebox, type a name of your choice. If the data is dynamic, then search for 'adding dynamic named ranges'.)
Then in your cell where you want the drop down, Choose Data->data Validation->data Validation->Allow=List->Source='=MyDataName'.
Give your list a name. (If the list is static, select list, then in Namebox, type a name of your choice. If the data is dynamic, then search for 'adding dynamic named ranges'.)
Then in your cell where you want the drop down, Choose Data->data Validation->data Validation->Allow=List->Source='=MyDataName'.
Upvote
0
