Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I'm trying to contruct a drop-down menu in Excel. The menu needs to include 10 names and their respective titles. This menu would be coped 10 times, in each of 10 selected cells. Once a name is selected, other cells will be automatically filled in. For example, if the drop-down menu selects a name that goes into cell A1, I can then use an IF statement to get the appropriate information for that person into their appropriate cells.
The drop-down menu is needed because there isn't any particular order in which the name are entered into the spreadsheet. Because of this, I would need many IF/OR statements so that the correct data is matched up with the correct name.
Name: DerbyDad03 Date: March 17, 2009 at 11:15:22 Pacific
Reply:
Are you asking for the instructions on how to create a dropdown?
Dropdowns are created using Data...Validation...Allow: List
In the Range that makes up the List, you would put the selections for the dropdown.
By using Named Ranges and the INDIRECT function, you can then populate other Dropdowns with different data depending on which item is selected in the first Dropdown.
Does that help?
0
Response Number 2
Name: Brian W Date: March 17, 2009 at 13:50:04 Pacific
Reply:
Thank you for your quick response; I was able to make the drop down menu I needed based upon your reply.
Summary: I am trying to create a drop down menu list in excel, I have seen it before in word but don't know how to set it up and guess it is also available in excel. It's not a drop down from a cell it's a dro...
Summary: How do I produce a range of answers in a cell where the answer changes depending on a value which has been chosen from a drop down menu. I am also working with text not numerical values. Any help woul...
Summary: I have an Excel sheet that I want to simplify for my users. I want to give them the ability to select data from a drop down and have the sheet prefill other columns based on their dropdown selection....