Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List on different worksheet
Hi
I am wanting to create a drop down list, however, I want the list of values to reside on a different worksheet, but when I do this, I get an error to say that the values must reside on the same worksheet. My lists are +200 values, and I wanted a central list I could refer to from multiple worksheets. Does anyone know how I could achieve this? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List on different worksheet
I just went through this. You can create a list of names, itens, etc on
another worksheet and have a dropdown list that references that data on onother sheet. On sheet "List" (contains data), list the items vertically in a column. Highlight the data (you can highlight blank cells below the list and if you add data it will be picked up), then name the list, Ex Last_Names On the sheet for the dropdown, choose cell for the dropdown, then DATA VALIDATION on the menu. Under Validation Criteria for "ALLOW:", choose "List" In the source box, type "=Last_Names" (without quotes). No need to reference the sheet within the source box. You may want to check out http://www.contextures.com/xlDataVal03.html Good Luck, Les "Lisa" wrote: Hi I am wanting to create a drop down list, however, I want the list of values to reside on a different worksheet, but when I do this, I get an error to say that the values must reside on the same worksheet. My lists are +200 values, and I wanted a central list I could refer to from multiple worksheets. Does anyone know how I could achieve this? Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List on different worksheet
Perfect. Just what I need Thanks Les "WLMPilot" wrote: I just went through this. You can create a list of names, itens, etc on another worksheet and have a dropdown list that references that data on onother sheet. On sheet "List" (contains data), list the items vertically in a column. Highlight the data (you can highlight blank cells below the list and if you add data it will be picked up), then name the list, Ex Last_Names On the sheet for the dropdown, choose cell for the dropdown, then DATA VALIDATION on the menu. Under Validation Criteria for "ALLOW:", choose "List" In the source box, type "=Last_Names" (without quotes). No need to reference the sheet within the source box. You may want to check out http://www.contextures.com/xlDataVal03.html Good Luck, Les "Lisa" wrote: Hi I am wanting to create a drop down list, however, I want the list of values to reside on a different worksheet, but when I do this, I get an error to say that the values must reside on the same worksheet. My lists are +200 values, and I wanted a central list I could refer to from multiple worksheets. Does anyone know how I could achieve this? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need data from one worksheet to be in a list in another worksheet. | Excel Discussion (Misc queries) | |||
Autocomplete from a list on the worksheet | Excel Worksheet Functions | |||
list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
form on one worksheet and the list on different worksheet | Excel Worksheet Functions | |||
List on different worksheet | Excel Discussion (Misc queries) |