Creating a Dropdown menu in Excell 2007

Can somebody please help me?

I have a document that I found online and I would like to do the same with a document I created that has similar type of information.

I try to copy the information and Ive tryed to look online for help but its hard to do when you dont know the correct terms, so I have attached the document in the hopes that one of you can help me.

If you look at Cell B4 on assettracking1.bmp youll see that it has a dropdown menu that pulls the data from the other sheet and displays it. How is that done?

Also if you look at Cell B20. Click on it "Manage Records" and you get text boxes that let you both modify the current records and create new records. The text box i shown in textbox1.jpg

Find more posts tagged with

Save $250 on 2025 certification boot camps from Infosec!

Book now with code EOY2025

Button

Comments

gandalphgp

To create a drop-down list from a range of cells, use the Validation command under the Data menu.
To create a list of valid entries for the drop-down list, type the entries in a single column or row without blank cells
If you want to use another worksheet or another workbook, do one of the following:
Use a different worksheet in the same workbook Type the list on that worksheet, and then define a [URL="javascript:AppendPopup(this,'IDH_xldefName_1_1')"]name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.)[/URL] for the list.
Use a different worksheet in a different workbook Type the list on that worksheet, and then define a name with an external reference to the list.

Select the cell where you want the drop-down list.
On the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.

To specify the location of the list of valid entries, do one of the following:
If the list is in the current worksheet, enter a reference to your list in the Source box.

If the list is on a different worksheet in the same workbook or a different workbook, enter the name that you defined for your list in the Source box.

In both cases, make sure that the reference or name is preceded with an equal sign (=). For example, enter =ValidDepts.
Make sure that the In-cell drop-down check box is selected.
To specify whether the cell can be left blank, select or clear the Ignore blank check box.
Optionally, display an input message when the cell is clicked.
Specify how you want Microsoft Office Excel to respond when invalid data is entered.
The width of the drop-down list is determined by the width of the cell that has the data validation. You may need to adjust the width of that cell to prevent truncating the width of valid entries that are wider than the width of the drop-down list.
The maximum number of entries that you can have in a drop-down list is 32,767.
If the validation list is on another worksheet in the same workbook or another workbook and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet

full description available here
http://office.microsoft.com/en-us/excel/HP052022151033.aspx