| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 07 / Data Validation / List /
When I want to use a list from a separate tab in Excel for drop down choices
I'm not able to Ctrl / Page Down to another tab in the excel workbook to select the list choices. I have to manually type in the location of the data in the "Source" box. Am I doing anything wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 07 / Data Validation / List /
Name the list, say, "MyList".
When you setup the DV cell, in the source box, type "=MyList" without the quotes. HTH Otto "WSR" wrote in message ... When I want to use a list from a separate tab in Excel for drop down choices I'm not able to Ctrl / Page Down to another tab in the excel workbook to select the list choices. I have to manually type in the location of the data in the "Source" box. Am I doing anything wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| How do I make a Validation List in Excel, using data on a second | Excel Discussion (Misc queries) | |||
| Excel, Data Validation List | Excel Discussion (Misc queries) | |||
| "Data Validation from list" Pocket excel ? | Excel Discussion (Misc queries) | |||
Linear Mode
