how do I share data validation lists between worksheets?

  • Thread starter Thread starter DL101
  • Start date Start date
e: how do I share data validation lists between worksheets?

In the future please put your subject in the subject line and question in
the BODY of the msg.
make a list somewhere and NAME it something like vallist. then

=vallist
 
That is, highlight the list, Insert > Name > Define and give it a name there.
 
Or, simply select the range and use the name box unless you want it to be
dynamic. Then use a formula such as offset to define your range name.
 
Thank you so much, it's my first time using the office online community, I
will definately use it again!
 
Thank you so much, it's my first time using the microsoft online community,
will definately use it again!
 
You must log in or register to reply here.

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

Data validation 3
Data Validation List Macro 18
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List: Text Size Query 2
Filesize: embedded data validation lists all stored independently? 2
Data Validation Dropdown List Not Working 4
Data Validation 4
Short listing the Data Validation List 2

Back
Top