ExcelBanter - USING DATA VALIDATION ACROSS SPREADSHEETS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - USING DATA VALIDATION ACROSS SPREADSHEETS (https://www.excelbanter.com/excel-worksheet-functions/110006-using-data-validation-across-spreadsheets.html)

scratching head

USING DATA VALIDATION ACROSS SPREADSHEETS

How can I get Data Validations working across different sheets in the
workbook i.e I want the validation in sheet 1 but use the data in sheet 2.

Gord Dibben

USING DATA VALIDATION ACROSS SPREADSHEETS

To use list source from another sheet you must name the source range.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlDataVal01.html#Name

Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 07:47:02 -0700, scratching head <scratching
wrote:

How can I get Data Validations working across different sheets in the
workbook i.e I want the validation in sheet 1 but use the data in sheet 2.

All times are GMT +1. The time now is 01:52 AM.