Items in Pick List

D

David Williams

Can anyone help. How do I create a "Pick List" by using a column of Data on
another sheet?

Thanks
 
A

Arvi Laanemets

Hi


David Williams said:
Can anyone help. How do I create a "Pick List" by using a column of Data on
another sheet?


Pick from List, which you get from right-click on cell? No way for it, there
are displayed only non-interrupted entries up from cell.

But fhen you did mean the list from Data.Validation, then define the list on
another sheet as named range, and refer to this named range.



Arvi Laanemets
 

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

Top