Data validation on multiple worksheets in the same workbook

's Computer Specifications

Can you have multiple worksheets in one workbook with data validation back to
one worksheet. For example I have all the data for the dropdown list in a
worksheet titled "data", I have five other worksheets in the same workbook I
want to make dropdown list from the "data" worksheet. Is this possible? I
keep getting and error message.

's Computer Specifications

If you name the validation list, you can refer to it on other sheets.
There are instructions here:

http://www.contextures.com/xlDataVal01.html

LTaylor wrote:
> Can you have multiple worksheets in one workbook with data validation back to
> one worksheet. For example I have all the data for the dropdown list in a
> worksheet titled "data", I have five other worksheets in the same workbook I
> want to make dropdown list from the "data" worksheet. Is this possible? I
> keep getting and error message.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Graphing data from multiple worksheets in same workbook	Lance Jacob	Microsoft Excel Misc	1	17th Sep 2008 04:23 AM
Pie charts with data from multiple worksheets in one workbook	Mary	Microsoft Excel Charting	0	7th Jul 2008 09:37 PM
Data Validation drop down for multiple worksheets	singla	Microsoft Excel Worksheet Functions	0	14th Dec 2005 05:56 PM
Move data from multiple worksheets to single workbook	=?Utf-8?B?VG9t?=	Microsoft Excel Worksheet Functions	1	15th Apr 2004 02:25 PM
validation list in multiple worksheets in a single workbook	=?Utf-8?B?Q29vdGVy?=	Microsoft Excel Worksheet Functions	1	23rd Mar 2004 03:34 AM