If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
List
Hello,
I am trying to create a list in a cell that references a name range on another sheet. The only way I know how to create a list currently is to reference a fixed range on the current sheet. How can I do this? Thank You, |
#2
|
|||
|
|||
List
Hi
on your other sheet select the range with your values. then goto 'Insert - Name - Define' and assign a name for this range. e.g. 'listdata' Now goto your other sheet and goto 'Data - Validation - List'. Enter the following as datasource: =listdata -- Regards Frank Kabel Frankfurt, Germany wrote: Hello, I am trying to create a list in a cell that references a name range on another sheet. The only way I know how to create a list currently is to reference a fixed range on the current sheet. How can I do this? Thank You, |
#3
|
|||
|
|||
List
Thank You
-----Original Message----- Hi on your other sheet select the range with your values. then goto 'Insert - Name - Define' and assign a name for this range. e.g. 'listdata' Now goto your other sheet and goto 'Data - Validation - List'. Enter the following as datasource: =listdata -- Regards Frank Kabel Frankfurt, Germany wrote: Hello, I am trying to create a list in a cell that references a name range on another sheet. The only way I know how to create a list currently is to reference a fixed range on the current sheet. How can I do this? Thank You, . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
outlook 2003 public folders of custom list | Lynda | Contacts | 1 | June 9th, 2004 01:25 PM |
finding & sorting unqiue names list | iwtci | Worksheet Functions | 6 | June 6th, 2004 06:43 AM |
How to make list of unique values? | JulieD | Worksheet Functions | 1 | February 26th, 2004 12:25 PM |
Multiple List function | George | Worksheet Functions | 8 | February 15th, 2004 10:13 AM |
Question: About using COUNTIF in a filtered list | acw | Worksheet Functions | 1 | February 11th, 2004 02:32 AM |