How to link drop-down list of a workbook in to another workbook?

[deepak]

Dear Expert,

Please let me know how to link a drop-down list in sheet1 of a workbook (say
Sparepart.xls) to a sheet in another workbook (say Estimation.xls).

Thanking you.

with regards
Deepak

 

[Dave Peterson]

Maybe this from Debra Dalgleish's site will help:
http://contextures.com/xlDataVal05.html

 

[Dave Peterson]

You have an active thread elsewhere.

Maybe this from Debra Dalgleish's site will help:
http://contextures.com/xlDataVal05.html

 

[deepak]

Dear Dave,

The link helped me to solve the problem. Thank you verymuch for the help.

May God bless you.

With regards
Deepak