LUIS FREUND
asked on
Records from Access to Excel to specific cells
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
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
The Excel file is called RFQ:
See attached files
C--Users-Luis.Freund.EXT-Desktop-E.accdb
C--Users-Luis.Freund.EXT-Desktop-Ex.xlsx
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
The Excel file is called RFQ:
See attached files
C--Users-Luis.Freund.EXT-Desktop-E.accdb
C--Users-Luis.Freund.EXT-Desktop-Ex.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it is possible, but it would be a different story.
post another question for the new requirement.
post another question for the new requirement.
ASKER
Thank you. Will post.....
ASKER
Thank you very much
ASKER
Is it possible that the combo box be placed on the actual excel file instead of a form in access?