Drop down list
 

I would like to create a drop down list for 12 names and a drop down list for
12 months that are relevant to the 12 names so that I can view their monthly
figures etc.
i.e. pick dave from one drop down list and January from the other to view
Daves figures from January. And how do I set up where I input the figures.

Drop down list
 

You should be able to find something here that answers your question

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

HTH,
Barb Reinhardt

"Rob" wrote:

I would like to create a drop down list for 12 names and a drop down list for
12 months that are relevant to the 12 names so that I can view their monthly
figures etc.
i.e. pick dave from one drop down list and January from the other to view
Daves figures from January. And how do I set up where I input the figures.

Drop down list
 

Hi Rob,

Try using Excel's Autofilter.

If you are not familiar with this feature, see Debra Dalgleish's
tutorial at:

Excel -- Filters -- AutoFilter Basics
http://www.contextures.com/xlautofilter01.html


---
Regards,
Norman


"Rob" wrote in message
...
I would like to create a drop down list for 12 names and a drop down list
for
12 months that are relevant to the 12 names so that I can view their
monthly
figures etc.
i.e. pick dave from one drop down list and January from the other to view
Daves figures from January. And how do I set up where I input the figures.

Drop down list
 

The DD is just a simple Data Validation.

To lookup results, using something like

=SUMPRODUCT(--(A2:A20=name_cell),--(B2:B20=month_cell),C2:C20)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rob" wrote in message
...
I would like to create a drop down list for 12 names and a drop down list
for
12 months that are relevant to the 12 names so that I can view their
monthly
figures etc.
i.e. pick dave from one drop down list and January from the other to view
Daves figures from January. And how do I set up where I input the figures.