Re: Drop Down Box

Giganews Newsgroups
Subject: Re: Drop Down Box
Posted by:  Debra Dalgleish (d…
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:

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



In response to

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