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
 
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!
 
Back
Top