J
j91co
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
" " " "
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
" " " "