Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11

Creating a list referring to another sheet in the same excel file.

1 réponse
Avatar
youjine
Hi all, i defined a list of items called vehicle on one spredsheet, and i
would like to create, on another spreadsheet, a dropping down list referring
to that list called vehicle, how do i do that? Those two sheets are in the
same excel file. Thanks.

1 réponse

Avatar
JB
Hello

-Affect a name to the list (MyList e.g.)
-Data/Validation/List
-=mylist

http://boisgontierjacques.free.fr/pages_site/donneesvalidation.htm#ListeAutreOnglet

JB
http://boisgontierjacques.free.fr/

On 10 mar, 14:34, youjine wrote:
Hi all, i defined a list of items called vehicle on one spredsheet, and i
would like to create, on another spreadsheet, a dropping down list referring
to that list called vehicle, how do i do that? Those two sheets are in the
same excel file. Thanks.