L
LenJr
I have an Excel workbook that I would like to have a macro run to update a
description field. This macro would link to an Access table and look up a
value and write it to a column in the open workbook. For example:
in my workbook I have column B that have project number in it (Range B2....)
and column C that I would like to populate with the project description. I
have an access database table tblProjects that has the Project number and
Description. I would like to run a macro that would connect to the access
database and use the value in Column B from the open Excel workbook and look
up that value on the tblProjects and write the Description in Column C of the
excel workbook. Some of the values in Column B will not be found on the
tblProject and I would like to skip those(not write any value in column C).
Thanks for any input.
description field. This macro would link to an Access table and look up a
value and write it to a column in the open workbook. For example:
in my workbook I have column B that have project number in it (Range B2....)
and column C that I would like to populate with the project description. I
have an access database table tblProjects that has the Project number and
Description. I would like to run a macro that would connect to the access
database and use the value in Column B from the open Excel workbook and look
up that value on the tblProjects and write the Description in Column C of the
excel workbook. Some of the values in Column B will not be found on the
tblProject and I would like to skip those(not write any value in column C).
Thanks for any input.