software

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.

On the sheet where you want the drop-down, define a name as the item list in
the other sheet (Insert gt; Name gt; Define). Then use that defined name as the
list in the dropdown.

quot;jweaslquot; wrote:

gt; I need to have my cell be a drop-down menu itself, and have the options
gt; reference a list in another sheet in the same workbook. I have a workbook in
gt; which it is done, but I can't figure out how they did it. I can't put a combo
gt; box over the cell, because then my vlookup formulas won't work when the value
gt; is selected.

Under the Data menu is the Validation option. In there, select List and
point to the list on the other page.quot;jweaslquot; wrote:

gt; I need to have my cell be a drop-down menu itself, and have the options
gt; reference a list in another sheet in the same workbook. I have a workbook in
gt; which it is done, but I can't figure out how they did it. I can't put a combo
gt; box over the cell, because then my vlookup formulas won't work when the value
gt; is selected.


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: www.excelforum.com/member.php...oamp;userid=29987
View this thread: www.excelforum.com/showthread...hreadid=496436