Creating a Drop Down List with Step by Step Instructions for 2007

[remarkable]

Hi, could someone please help me with step by step instructions on setting up
a drop down list for Excel 2007. The names of my files are as follows. The
file name which contains my list is called "Price Workbook". The list is A1
to A10 on the first tab called Materials. It is a list of Materials. The file
which I would like to put my drop down list in is called "Quotation
Workbook". Is there anything else I need to tell you before you can give me
instructions, in laymans terms, on how to exactly put this drop down list
into place. Please do not give me links to web pages with instructions, as
unless they are exact with screen dumps and for Excel 07, then I get quite
confused. Please Please help me anyone? Thanks. P.S. My e-mail address is
(e-mail address removed) if anyone would like to send me anything to
help also.

 

[Jacob Skaria]

Refer http://office.microsoft.com/en-us/excel/HP100725991033.aspx

OR refer another interesting article on drop down lists

http://www.homeandlearn.co.uk/excel2007/excel2007s8p3.html

If this post helps click Yes

 

[Sheeloo]

Steps
1. Create a Name (Navigation Formula->Name Manager->New] 'MaterialList'
referring to A1:A10 in 'Price Workbook.xlsx'
2. Creat a Name in the 'Quotation Workbook.xlsx' workbook called 'MyList'
and enter the addres as ='Price Workbookxlsx'!MaterialList
3. In 'Quotation Workbook.xlsx', select A2:A11, Choose Data Validation
[Navigation Data->Data Validation], Choose List and enter the formula as
=MyList


Mail sent to your id with sample files...