Create drop down that will show a range.
 

I am pretty new to using the drop down list function, I can't seem to figure
out how to do this a certain way. I would like to create a drop down list for
years 2003-2010, when a year in the list is selected I would like a certain
range of cells to come into view. Ideally a user will be able to do this to
see only the data that applies to the year they selected instead of having to
scroll down the entire xls file. I have shown how the data for each year is
laid out below to better illustrate what I want to show when a year is
selected. This a tool that will be used throughout my company so I am trying
to make it as convenient and easy to use as possible. Any suggestions are
appreciated.

Selected from dropdown --2003

2003
Lower Upper
Date Reading Date Reading
01/31/2003 123 01/31/2003 456
" " " "

Create drop down that will show a range.
 

add one colum with, write the year of each entry in this column. make a
filter for this column, the dropdown will only show the years
available.

from a date in a1 you can get the year with

=year(a1)

arno