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

Excel Move or Copy Stopped Working? 0
Drop Down List + Validation 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Merge Multiple workbook sheets into one workbook 0
Dependent list in excel to create validation 1
Count the columns from one sheet and paste it in another sheet 0
How to optimize? large non-contig cell range for data validation l 5
[err] Excel 2007 - Data validation from another sheet? 1

Top