Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |