Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Drop Down List with Step by Step Instructions for 2007
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 if anyone would like to send me anything to help also. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Drop Down List with Step by Step Instructions for 2007
Refer http://office.microsoft.com/en-us/ex...725991033.aspx
OR refer another interesting article on drop down lists http://www.homeandlearn.co.uk/excel2...l2007s8p3.html If this post helps click Yes -------------- Jacob Skaria "remarkable" wrote: 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 if anyone would like to send me anything to help also. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Drop Down List with Step by Step Instructions for 2007
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... "remarkable" wrote: 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 if anyone would like to send me anything to help also. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone povide step by step instructions on how to do the follo | Excel Discussion (Misc queries) | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |