Auto-fill

[deanl33069]

I have a dropdown list on sheet 1 , the data is on sheet 2.
is there a way of making the list autofill?

 

[Yongle]

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