Re: Drop Down Box

Giganews Newsgroups
Subject: Re: Drop Down Box
Posted by:  Debra Dalgleish (d…@contexturesXSPAM.com)
Date: Sat, 04 Oct 2003

You can use Data>Validation, and refer to a named range on the second
sheet. There are some instructions here:

  http://www.contextures.com/xlDataVal01.html

harefeld wrote:
> There is a drop down box that can be inserted in a
> spreadsheet that will go to a second sheet, and will show
> a listing of names and allow you to pick the exact name on
> the second sheet and show it on the first sheet.  Can
> anyone tell me how to get this drop down box?  Thanks.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Replies

None

In response to

Drop Down Box posted by harefeld on Sat, 4 Oct 2003