deanl33069
Board Regular
- Joined
- May 2, 2019
- Messages
- 120
I have a dropdown list on sheet 1 , the data is on sheet 2.
is there a way of making the list autofill?
is there a way of making the list autofill?
-
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.
Yongle
Well-known Member
- Joined
- Mar 11, 2015
- Messages
- 6,977
- Office Version
- 365
- Platform
- Windows
in Excel autofill refers to cells being filled via dragdown etc
- but I do not think that is what you want
Do you want the DROPDOWN list to use the current values in sheet2 ?
- if so, then use a Dynamic Named Range as the source of your dropdown
Have a look at this link
https://www.contextures.com/xlNames01.html
Last edited:
Upvote
0
Similar threads
- Question
