Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation list
Is there a way of using a list from another worksheet without having
to bring the list into the current worksheet? |
#2
|
|||
|
|||
Hi!
Use a defined name. Sheet2!A1:A10 named List Data validation Allow list Source =List Biff -----Original Message----- Is there a way of using a list from another worksheet without having to bring the list into the current worksheet? . |
#3
|
|||
|
|||
If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions he http://www.contextures.com/xlDataVal01.html smskater wrote: Is there a way of using a list from another worksheet without having to bring the list into the current worksheet? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
On Wed, 22 Dec 2004 07:33:20 -0500, Debra Dalgleish
wrote: If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions he http://www.contextures.com/xlDataVal01.html smskater wrote: Is there a way of using a list from another worksheet without having to bring the list into the current worksheet? Thank-you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Drop dow list complication | Excel Discussion (Misc queries) | |||
List Box refer to an array | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |