Using Validation list from other sheet

F

Fgomez

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

Thanks

Fernando
 
P

Peo Sjoblom

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

=MyList
 
F

Fgomez

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...
 
Top