Creating a list from another sheet or workbook

W

walrus

How can i create a list (from Data Validation) based on data in another
sheet or work book?
 
J

Jacob Skaria

Create a named range of data in another sheet and refer the named range in
the list source...
 
W

walrus

Yes...

One more thing...the list is alphabetical and 600 items long so if i have to
go to somewhere in the middle or the end, i have to scroll all the way
there...any option to maybe auto-complete the text i am typing or go to at
the point where the type alphabets start or something else?


thanks..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Word List Bug 0
Dealing with the error: unable to filter on excel hc home school 0
Found few bugs in my daily routine of work in excel for MAC 0
Designate font as italic of another 0
Found few bugs in my daily routine of work in excel for MAC 0
Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
Help with drop down selection and populating related data... 9

Top