how to create drop down list from one excel file to another excel.
Dear sir,
I have maintaing stock list in a work sheet i want a drop down list in another work book how ? Thnks Saravanan.G |
how to create drop down list from one excel file to anotherexcel.
check it here
http://www.contextures.com/xlDataVal05.html On Nov 29, 7:31*pm, Saravanan.G wrote: Dear sir, * I have maintaing stock list in a work sheet * * *i want a drop down list in another work book * * * *how ? * *Thnks Saravanan.G |
how to create drop down list from one excel file to another excel.
Hi,
Here is an example of applying data validation between workbooks: 1. In the one workbook name the range containing the items you want listed, here I named it Months. (highlight the range and choose Insert, Name, Define, type Months into the Names in workbook box and click OK). 2. Move to the workbook where you want to display the list and choose Insert, Name, Define and in the Names in workbook box enter List. In the Refers to enter something of the form ='10-21-2008.xls'!Months 3. Select the range where you want the list and choose Data, Validation, List 4. In the Source box enter =List If this helps, please click the Yes button Cheers, Shane Devenshire "Saravanan.G" wrote: Dear sir, I have maintaing stock list in a work sheet i want a drop down list in another work book how ? Thnks Saravanan.G |
All times are GMT +1. The time now is 03:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com