ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to link drop-down list of a workbook in to another workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/218157-how-link-drop-down-list-workbook-another-workbook.html)

Deepak

How to link drop-down list of a workbook in to another workbook?
 
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

How to link drop-down list of a workbook in to another workbook?
 
Maybe this from Debra Dalgleish's site will help:
http://contextures.com/xlDataVal05.html

deepak wrote:

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

Dave Peterson

How to link drop-down list of a workbook in to another workbook?
 
You have an active thread elsewhere.

Dave Peterson wrote:

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

deepak wrote:

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


--

Dave Peterson

Deepak

Thank you
 
Dear Dave,

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

May God bless you.

With regards
Deepak

"Dave Peterson" wrote:

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

deepak wrote:

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



All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com