| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
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" wrote: 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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
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" wrote in message ... 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" wrote: 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
Ok So how do I do that, and do you have these terms in french? or
"Tyro" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
Don't know what you mean by "list".
What type of list? How created? How used? Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 08:46:35 -0800, Pascale wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
Déroulante in English means "descend" or "unfold"
If a dropdown list is created by DataValidationList, the same list can be used on other sheet if you first give the list a defined name. Select the list and InsertNameDefine. Name it MyList. On other sheet use the =MyList in the source dialog. Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 09:15:03 -0800, Pascale wrote: 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" wrote: 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" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
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" wrote: Déroulante in English means "descend" or "unfold" If a dropdown list is created by DataValidationList, the same list can be used on other sheet if you first give the list a defined name. Select the list and InsertNameDefine. Name it MyList. On other sheet use the =MyList in the source dialog. Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 09:15:03 -0800, Pascale wrote: 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" wrote: 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" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
Was my guess about DataValidationDropdown List correct?
If so, see this website for how to do it. http://www.contextures.on.ca/xlDataVal01.html Gord On Mon, 4 Feb 2008 17:57:02 -0800, Pascale wrote: 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" wrote: Déroulante in English means "descend" or "unfold" If a dropdown list is created by DataValidationList, the same list can be used on other sheet if you first give the list a defined name. Select the list and InsertNameDefine. Name it MyList. On other sheet use the =MyList in the source dialog. Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 09:15:03 -0800, Pascale wrote: 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" wrote: 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Linear Mode
