Hello Experts,
I need assistance in writing VBA to transfer data from an access table to specific cells in an existing Excel file. This process is updating the worksheet with results from Access.
Below is an example of what I am trying to do, update the worksheet in the M&I Notes cells with the comment “ADD “ & EFF_DT.
Access table:
POSITION NO EMPLID FULL NAME POSITION TYPE EFF_DT
1234567 1000001 LAST, FIRST Team Member 3/6/2016
2345678 1000002 LAST, SECOND Team Member 3/6/2016
3456789 1000003 LAST, THIRD Team Member 3/10/2016
4567891 1000004 LAST, FOURTH Team Member 3/14/2016
5678912 1000005 LAST, SIXTH Team Member 3/14/2016
Excel Workbook:
Position Type M&I Notes POSITION NO EMPLID FULL NAME
Team Member 1234567 1000001 LAST, FIRST
Team Member 2345678 1000002 LAST, SECOND
Team Member 3456789 1000003 LAST, THIRD
Team Member 4567891 1000004 LAST, FOURTH
Team Member 5678912 1000005 LAST, FIFTH
Ultimate results:
Position Type M&I Notes POSITION NO EMPLID FULL NAME
Team Member ADD 3/6/2016 1234567 1000001 LAST, FIRST
Team Member ADD 3/6/2016 2345678 1000002 LAST, SECOND
Team Member ADD 3/10/2016 3456789 1000003 LAST, THIRD
Team Member ADD 3/14/2016 4567891 1000004 LAST, FOURTH
Team Member ADD 3/14/2016 5678912 1000005 LAST, FIFTH
Thanks in advance.
Wouldn't be easier to create a query to have the wanted result and then Export the result to Excel thanks
Open in new window
Regards