Data Validation List

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

Is it possible to refer to a list in another worksheet to
the one where you have set up the data validation?

I have a list in one worksheet that I need to refer to in
about 25 other worksheets, if this is not possible can
anyone think of a workaround?

TIA
 
You need to define a name for your list (select the range,
press Ctrl+F3, and then give it a name), and then refer to
that name in Validation. If you named it "mylist", then
use:

=mylist

in Validation under List.

HTH
Jason
Atlanta, GA
 
Back
Top