Hi,

I know you can create a dropdown box with data from somewhere in the
spreadsheet, but can you have the data in another file?

I'm making a quote form for a customer and he wants to select from a
list of customers in another spreadsheet. For security reasons, we
can't have his customer list in his quote file.

Any ideas would be greatly appreciated.

Michele

You can do this if the other workbook is open. There are instructions he

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

wrote:
Hi,

I know you can create a dropdown box with data from somewhere in the
spreadsheet, but can you have the data in another file?

I'm making a quote form for a customer and he wants to select from a
list of customers in another spreadsheet. For security reasons, we
can't have his customer list in his quote file.

Any ideas would be greatly appreciated.

Michele



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi

Only if the other workbook is open.


Doug


wrote in message
.com...
Hi,

I know you can create a dropdown box with data from somewhere in the
spreadsheet, but can you have the data in another file?

I'm making a quote form for a customer and he wants to select from a
list of customers in another spreadsheet. For security reasons, we
can't have his customer list in his quote file.

Any ideas would be greatly appreciated.

Michele