Hi,
I'm not sure what this will require (programming, macros, etc), but what I
want to do is create a cell that has a drop down list of selectable items (in
this case industries) so that I can create reports on securities. Rather than
type in the industry and industry info every time, I would like to just
select the particular industry and have the rest of the information come up
from there.
I am familiar with the formulas, and can do a lot of the basics, but I need
some direction for this. Any help would be appreciated. Thanks.

Start here:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ybkusz" <(E-Mail Removed)> wrote in message
news:5CBB6BA7-A342-45FC-903A-(E-Mail Removed)...
> Hi,
> I'm not sure what this will require (programming, macros, etc), but what I
> want to do is create a cell that has a drop down list of selectable items
(in
> this case industries) so that I can create reports on securities. Rather
than
> type in the industry and industry info every time, I would like to just
> select the particular industry and have the rest of the information come
up
> from there.
> I am familiar with the formulas, and can do a lot of the basics, but I
need
> some direction for this. Any help would be appreciated. Thanks.