From Access to Excel Populating a Drop-Down menu +

[TonyU]

[tt]Hello all, here's what I'm trying to accomplish

I need to connect to an access database and populate a drop-down company field in excel and when the company field is selected I would like to also dynamically populate address, city, state, zip & phone number corresponding to the company selected. How possible and or difficult is this?

You assistance is greatly appreciated

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​