If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop down box
Hello everyone. I hope someone can help with this question:
I have a worksheet that, using the INDIRECT function takes information from a specific cell on another sheet. The INDIRECT function references 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 the month and year so that instead of having to type April 2004 it takes the value from a list. Is this possible. Any and all help appreciated. Thanks Scott. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Drop down box
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 -----Original Message----- Hello everyone. I hope someone can help with this question: I have a worksheet that, using the INDIRECT function takes information from a specific cell on another sheet. The INDIRECT function references 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 the month and year so that instead of having to type April 2004 it takes the value from a list. Is this possible. Any and all help appreciated. Thanks Scott. --- Message posted from http://www.ExcelForum.com/ . |
#3
|
|||
|
|||
Drop down box
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel 97 vba - need to associate values with drop down list choice | chief | General Discussion | 15 | July 23rd, 2004 11:52 PM |
Drop downs | Neil R | General Discussion | 2 | June 16th, 2004 12:00 AM |
linking drop down menu items to corresponding items in other lists | Jklay | General Discussion | 2 | June 15th, 2004 07:42 PM |
Values in drop down box dynamic | Chris | Worksheet Functions | 1 | May 8th, 2004 07:25 AM |
Drop drow box - Help! | Crystal | Worksheet Functions | 4 | January 23rd, 2004 07:50 PM |