Excel Macro to update colums in file1 from file2
- or -
Post a project like this1143
$25
- Posted:
- Proposals: 2
- Remote
- #3173563
- Awarded
Description
Experience Level: Entry
Need Macro in Excel for this project
My Goal is to update Columns in FILE_1 from FILE_2
1st column for both files will be the same ID (for LOOKUP)
Read Column 1 in (FILE_2) lookup Column 1 (FILE_1)
(we are adding or updating 3+ colums in FILE_1
IF ID in FILE_2 not in (FILE_1) THEN
Add NEW ROW 3+ columns from FILE_2 to FILE_1
From (FILE_2) to (FILE_1)
e.g
CONTACT_NAME to CONTACT_NAME1
EMAIL to EMAL_1
CONTACT_ROLE to DEPT_1
For ID already exists in both (FILE_2) and FILE_1)
No updated on the original contact
for multiple contact info for the same ID’s
add new columns to FILE_1 (XX - NUMBER OF OTHER CONTACT)
CONTACT_NAMEXX
EMAIL_XX
DEPT_XX
e.g
My Goal is to update Columns in FILE_1 from FILE_2
1st column for both files will be the same ID (for LOOKUP)
Read Column 1 in (FILE_2) lookup Column 1 (FILE_1)
(we are adding or updating 3+ colums in FILE_1
IF ID in FILE_2 not in (FILE_1) THEN
Add NEW ROW 3+ columns from FILE_2 to FILE_1
From (FILE_2) to (FILE_1)
e.g
CONTACT_NAME to CONTACT_NAME1
EMAIL to EMAL_1
CONTACT_ROLE to DEPT_1
For ID already exists in both (FILE_2) and FILE_1)
No updated on the original contact
for multiple contact info for the same ID’s
add new columns to FILE_1 (XX - NUMBER OF OTHER CONTACT)
CONTACT_NAMEXX
EMAIL_XX
DEPT_XX
e.g
Jyotin P.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
25%
Last project
24 Feb 2021
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies