ExcelBanter - Data Valadation

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

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

- - Data Valadation (https://www.excelbanter.com/excel-worksheet-functions/213717-data-valadation.html)

Jeff

Data Valadation

Does a data list for cell valadation have to be on the same work sheet?

Thanks!
--
Jeff

Carim[_2_]

Data Valadation

No ... As long as you Insert Name Define your range ...

HTH

Jarek Kujawa[_2_]

Data Valadation

yes, in Excel 2003

On 15 Gru, 15:01, Jeff wrote:
Does a data list for cell valadation have to be on the same work sheet?

Thanks!
--
Jeff

Jeff

Data Valadation

Excel 2002 as well?
--
Jeff

"Jarek Kujawa" wrote:

yes, in Excel 2003

On 15 Gru, 15:01, Jeff wrote:
Does a data list for cell valadation have to be on the same work sheet?

Thanks!
--
Jeff

Gord Dibben

Data Valadation

Incorrect Jarek

If you first give the list on sheet2 a defined name like MyName you can use
that defined name in sheet1 DV list source

Type =MyName into the source refedit dialog.

Gord

On Mon, 15 Dec 2008 06:37:01 -0800 (PST), Jarek Kujawa
wrote:

yes, in Excel 2003

On 15 Gru, 15:01, Jeff wrote:
Does a data list for cell valadation have to be on the same work sheet?

Thanks!
--
Jeff

All times are GMT +1. The time now is 10:02 AM.