Lists

P

Pascale

Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale
 
T

Tyro

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro
 
P

Pascale

Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again
 
T

Tyro

You're talking about a list box or combo box. You'll have to create it again
on the second sheet. You can insert a form control or Active X control on
the second sheet and refer to the original list on the first sheet -
ListFillRange and set your LinkedCell to the cell you want on the second
sheet.

Tyro
 
G

Gord Dibben

Don't know what you mean by "list".

What type of list?

How created?

How used?


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Déroulante in English means "descend" or "unfold"

If a dropdown list is created by Data>Validation>List, the same list can be used
on other sheet if you first give the list a defined name.

Select the list and Insert>Name>Define.

Name it MyList.

On other sheet use the =MyList in the source dialog.


Gord Dibben MS Excel MVP
 
P

Pascale

Something is not workin, maybe I can send you my file, And waht do you mean
by in the source dialog, do you mean in the cell?

TK
 
Top