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