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

Le
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.
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
JB
Le #5231051
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
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.


Publicité
Poster une réponse
Anonyme