Data validation on multiple worksheets in the same workbook
 

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.

Data validation on multiple worksheets in the same workbook
 

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

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