| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Valadation
Does a data list for cell valadation have to be on the same work sheet?
Thanks! -- Jeff |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Valadation
No ... As long as you Insert Name Define your range ... HTH |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Valadation | Excel Discussion (Misc queries) | |||
| Using a Hyperlink with Data Valadation | Excel Discussion (Misc queries) | |||
| Using a Hyperlink with Data Valadation | Excel Discussion (Misc queries) | |||
| Data Valadation - | Excel Worksheet Functions | |||
| Data Valadation help | Excel Worksheet Functions | |||
Hybrid Mode
