Populating Cells in excel using a combo box in excel from an access table or query.
What I'm trying to accomplish is getting data from a table in Access to Excel only populating certain cells within an Excel Sheet by selecting the Supplier Name from a drop down box that user selects. The Combo Box selection is in the Excel file.
I have a database called Supplier
For example: Table Called Supplier. When the user selects a Supplier name it populates the following:
Supplier_Name to cell B3
Supplier_Address to cell B4
Supplier_City to cell B5
Supplier_ST to cell C5
Supplier_Zip to cell B6
Supplier_POC to cell B9
Supplier_Phone to cell B12
Supplier_Fax to cell B15