| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LINK ONE CELL TO AN ENTIRE LIST
In one cell for a worksheet, I would like to pick from an entire "list of
codes" in another worksheet and have that tied into a separate price for each code. (Trying to put togehter a Summary Sheet) Can this be accomplished? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
LINK ONE CELL TO AN ENTIRE LIST
1-Name the range that you want as the drop down list.
2-Then use data validation to create an in-cell drop down list (Data Validation) -- JNW "thaenn" wrote: In one cell for a worksheet, I would like to pick from an entire "list of codes" in another worksheet and have that tied into a separate price for each code. (Trying to put togehter a Summary Sheet) Can this be accomplished? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link the content of a cell with a related list of items | Excel Worksheet Functions | |||
| have an entire row populate with a link when the data in a cell ch | Excel Worksheet Functions | |||
| have an entire row populate with a link when the data in a cell ca | Excel Worksheet Functions | |||
| How do I populate an entire row by choosing one cell from a list | Excel Discussion (Misc queries) | |||
| How can I link one cell to a list of info in another workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
