Drop down box

[scottwilsonx]

Hello everyone. I hope someone can help with this question:
I have a worksheet that, using the INDIRECT function takes informatio
from a specific cell on another sheet. The INDIRECT function reference
to a cell which includes a Month and Year, for Example "April 2004"
and then takes the value in cell A10 of April 2004 etc.
What I want is to create a drop down box in the cell containing th
month and year so that instead of having to type April 2004 it take
the value from a list.

Is this possible. Any and all help appreciated.

Thanks

Scott

 

[Jason Morin]

One way is through validation. MVP Debra Dalgleish has
some nice instructions on using validation:

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

HTH
Jason
Atlanta, GA

 

[scottwilsonx]

Thanks, works a treat