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.