how do I share data validation lists between worksheets?

[Don Guillett]

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

 

[Dave Peterson]

I'd start at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html#Name

DL101 wrote:

 

[Sean Timmons]

That is, highlight the list, Insert > Name > Define and give it a name there.

 

[Don Guillett]

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.

 

[DL101]

Thank you so much, it's my first time using the office online community, I
will definately use it again!

 

[DL101]

Thank you so much, it's my first time using the microsoft online community,
will definately use it again!