On Nov 28, 10:52*am, Andrew wrote:
Hello,
I am working on a project where I would like to have a customer
database in one workbook, and an invoice/PO generator in another
workbook. *The PO generator will have either a drop down list or a
combo box which is linked to the customer database. *The drop down
list would show all the customers and information about the customer
database.

I would like to use a drop down list on the PO sheet, so that a user
can scroll through all possible customers. *But I have learned that a
drop down list can only be validated when the reference workbook is
open. *And I would prefer that the customer database workbook remain
closed. *So, first of all...can this be done with a drop down list?
If so, how? *And...if it can't be done with a drop down list, what's
the next choice? *I had assumed using a userform with a combo box
which contains a drop down list of customers.

Thanks in advance for your help.

Andy

One possible way to do this without opening the source wb would be to
have formulas refer to the workbook and an edit/replace macro to
change the formula for the customer ??