Lists

[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

 

[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

 

[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

 

[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

 

[Pascale]

Ok So how do I do that, and do you have these terms in french? or

 

[Gord Dibben]

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

What type of list?

How created?

How used?


Gord Dibben MS Excel MVP

 

[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

 

[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

 

[Gord Dibben]

Was my guess about Data>Validation>Dropdown List correct?

If so, see this website for how to do it.

http://www.contextures.on.ca/xlDataVal01.html


Gord