Hi
I would like a VBA code to look for the Employer Name (Column B) on a workbook name ExtOrgsList.xlsx then return the value on column A to a different workbook for example ImportName.csv both files are in the same folder.
the search should start from row 5 and all the way to the last record.
Sample Data of ExtOrgsList.xlsx
A B
310001 Employer Name 1
310002 Employer Name 2
310003 Employer Name 3
310004 Employer Name 4
then this info should copy and replace the value that are in column AN of the file ImportName.csv
Sample Data of ImportName.csv BEFORE the code
AN
Employer Name 1
Employer Name 2
Employer Name 3
Employer Name 4
Sample Data of ImportName.csv AFTER the code
AN
310001
310002
310003
310004
Thank you thank you so much in advance
I would like a VBA code to look for the Employer Name (Column B) on a workbook name ExtOrgsList.xlsx then return the value on column A to a different workbook for example ImportName.csv both files are in the same folder.
the search should start from row 5 and all the way to the last record.
Sample Data of ExtOrgsList.xlsx
A B
310001 Employer Name 1
310002 Employer Name 2
310003 Employer Name 3
310004 Employer Name 4
then this info should copy and replace the value that are in column AN of the file ImportName.csv
Sample Data of ImportName.csv BEFORE the code
AN
Employer Name 1
Employer Name 2
Employer Name 3
Employer Name 4
Sample Data of ImportName.csv AFTER the code
AN
310001
310002
310003
310004
Thank you thank you so much in advance