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

check it here

http://www.contextures.com/xlDataVal05.html



On Nov 29, 7:31*pm, Saravanan.G
<Saravana...@discussions.microsoft.com> 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

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