Drop down list

D

David T

I'm trying to create a drown down list in excel that is link to a query in
access. Right now i create a list in the workbook I'm working on, then use a
validation option in the Data menu to create the drop down.

I want to use an Acccess file as a central location where people can add new
items to the drop down list. I don't know if this is possible, but if anyone
knows how to do this, please help!!!!!!!!!!!
 
D

Debra Dalgleish

In Excel, you could use Data>Get External Data>New Database Query, and
pull the data from the query onto a worksheet.

When you import the data, a name is automatically created, e.g. Query
from MS Access Database. Use that name as the source for the data
validation list, and it will automatically adjust.
 
Top