Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup of data
I hope someone here can help me. I am not a "high-end" user of Excel but I
do know my way around. I often use Data Validation Lists to allow me to select a value from a list. The problem I have is that this method will not call up data from another worksheet. What I want to do, for example, is to be able to have a list of usernames on one worksheet, and from another worksheet, click on a cell and have a drop down box where I can select a username in the list in the first worksheet. It wouldn't be a problem if it was only one instance but there will be several worksheets calling values from the list and several cells on each one. If anyone has an easy way of doing this then please, please let me know. Many thanks Andy Baldwin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup of data
If your list is on another worksheet, you'll need to name the list range.
Select the list InsertNameDefine Names in Workbook: LU_MyList refers to: (your already selected list) Click the [OK] button Now refer to LU_MyList in your Data Validation. For LOTS more information on Data Validation see Debra Dalgleish's website: http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Boggis2000" wrote: I hope someone here can help me. I am not a "high-end" user of Excel but I do know my way around. I often use Data Validation Lists to allow me to select a value from a list. The problem I have is that this method will not call up data from another worksheet. What I want to do, for example, is to be able to have a list of usernames on one worksheet, and from another worksheet, click on a cell and have a drop down box where I can select a username in the list in the first worksheet. It wouldn't be a problem if it was only one instance but there will be several worksheets calling values from the list and several cells on each one. If anyone has an easy way of doing this then please, please let me know. Many thanks Andy Baldwin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup of data
Thanks for your help, problem solved!
"Ron Coderre" wrote: If your list is on another worksheet, you'll need to name the list range. Select the list InsertNameDefine Names in Workbook: LU_MyList refers to: (your already selected list) Click the [OK] button Now refer to LU_MyList in your Data Validation. For LOTS more information on Data Validation see Debra Dalgleish's website: http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Boggis2000" wrote: I hope someone here can help me. I am not a "high-end" user of Excel but I do know my way around. I often use Data Validation Lists to allow me to select a value from a list. The problem I have is that this method will not call up data from another worksheet. What I want to do, for example, is to be able to have a list of usernames on one worksheet, and from another worksheet, click on a cell and have a drop down box where I can select a username in the list in the first worksheet. It wouldn't be a problem if it was only one instance but there will be several worksheets calling values from the list and several cells on each one. If anyone has an easy way of doing this then please, please let me know. Many thanks Andy Baldwin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Altering data that was called with LOOKUP | Excel Discussion (Misc queries) | |||
Limiting the range of a lookup function | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Lookup Access data in Excel | Excel Worksheet Functions |