Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert drop-down into a cell?
I need to have my cell be a drop-down menu itself, and have the options
reference a list in another sheet in the same workbook. I have a workbook in which it is done, but I can't figure out how they did it. I can't put a combo box over the cell, because then my vlookup formulas won't work when the value is selected. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert drop-down into a cell?
On the sheet where you want the drop-down, define a name as the item list in
the other sheet (Insert Name Define). Then use that defined name as the list in the dropdown. "jweasl" wrote: I need to have my cell be a drop-down menu itself, and have the options reference a list in another sheet in the same workbook. I have a workbook in which it is done, but I can't figure out how they did it. I can't put a combo box over the cell, because then my vlookup formulas won't work when the value is selected. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert drop-down into a cell?
Under the Data menu is the Validation option. In there, select List and
point to the list on the other page. "jweasl" wrote: I need to have my cell be a drop-down menu itself, and have the options reference a list in another sheet in the same workbook. I have a workbook in which it is done, but I can't figure out how they did it. I can't put a combo box over the cell, because then my vlookup formulas won't work when the value is selected. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert drop-down into a cell?
I need to be able to retrieve text from a list as I type the first letters of the word.. any clues? Thanks! -- Raydel ------------------------------------------------------------------------ Raydel's Profile: http://www.excelforum.com/member.php...o&userid=29987 View this thread: http://www.excelforum.com/showthread...hreadid=496436 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a value in one cell into many cells | Excel Worksheet Functions | |||
How to change drop down values based on another cell value? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |