Data validation on different sheets?

's Computer Specifications

Hi,

I've noticed that when I try to create a dropdown (Data/Validation/List), it
does not allow me to move to another sheet to select the source of the list.
I'm hoping someone can tell me that I can indeed have a source in a sheet
other than where data entry will take place.

Thanks.

's Computer Specifications

When referencing a list from another worksheet the list must be named and the
name used for the source:

=ListValues

Kevin

's Computer Specifications

Read this page and all will become clear...

http://www.cpearson.com/excel/named.htm
--
HTH...

Jim Thomlinson

"ppsa" wrote:

> Hi,
>
> I've noticed that when I try to create a dropdown (Data/Validation/List), it
> does not allow me to move to another sheet to select the source of the list.
> I'm hoping someone can tell me that I can indeed have a source in a sheet
> other than where data entry will take place.
>
> Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to set-up data validation between sheets?	=?Utf-8?B?Um9iUw==?=	Microsoft Excel Worksheet Functions	1	10th Jul 2007 06:04 PM
Populating multiple cells on other sheets via data validation	kuansheng	Microsoft Excel Programming	0	14th Feb 2006 06:08 AM
Data Validation Lists Across Sheets	=?Utf-8?B?TWljaGFlbCBMaW5r?=	Microsoft Excel Misc	10	13th Sep 2005 02:54 AM
data validation across sheets	=?Utf-8?B?R2l4eGVyX0pfOTc=?=	Microsoft Excel Programming	2	10th Mar 2005 10:05 PM
When pasting data into a column with data validation I lose validation check	Brad	Microsoft Excel Misc	5	17th Apr 2004 01:11 PM