Using Validation list from other sheet

  • Thread starter Thread starter Fgomez
  • Start date Start date
F

Fgomez

I am trying to get a validation list from another sheet in the same file, is
this possible?.

Thanks

Fernando
 
Yes, but you need to name the range (insert<name>define) then instead of
=Sheetx!A2:A3 refer to the name i.e

=MyList
 
Thanks Peo

Peo Sjoblom said:
Yes, but you need to name the range (insert<name>define) then instead of
=Sheetx!A2:A3 refer to the name i.e

=MyList


--

Regards,

Peo Sjoblom


file,
Click to expand...
 
Back
Top