illuminate
New Member
- Joined
- May 29, 2015
- Messages
- 2
I have been trying to achieve this for a while. Thank you in advance for your help.
This will be a script that will be based on 2 excel files: fileA and fileB (if you can't do this with different excel or sheets then consider having all date in one sheet but in different columns, obviously)
use Column A in fileA as a way to connect to Column X in fileB;
if column A and X data matches then copy all the data in the same row from column X to the infinite right.
Maybe I confuse you with this explanation, but here is an example; let's assume we have in fileA we have these columns:
A) Phone Number (as identifier)
B) Name
C) Surname
D) Address
and I have fileB with columns:
E) Phone Number (as an identifier)
F) country
G) zip
H) Car Brand
Now, I want to be able to match the entire row and column from excel fileA column A with fileB column E.
After we match them we need to copy everything from column F,G,H of fileB and move it to FileA and paste it in columns E,F,G.
So, we copy paste everything including titles and all the column from original file, but we make sure it is also matching in the same row as the phone number (identifier).
Can this be a single script or will it be many scripts? Can someone guide me in doing this?
This will be a script that will be based on 2 excel files: fileA and fileB (if you can't do this with different excel or sheets then consider having all date in one sheet but in different columns, obviously)
use Column A in fileA as a way to connect to Column X in fileB;
if column A and X data matches then copy all the data in the same row from column X to the infinite right.
Maybe I confuse you with this explanation, but here is an example; let's assume we have in fileA we have these columns:
A) Phone Number (as identifier)
B) Name
C) Surname
D) Address
and I have fileB with columns:
E) Phone Number (as an identifier)
F) country
G) zip
H) Car Brand
Now, I want to be able to match the entire row and column from excel fileA column A with fileB column E.
After we match them we need to copy everything from column F,G,H of fileB and move it to FileA and paste it in columns E,F,G.
So, we copy paste everything including titles and all the column from original file, but we make sure it is also matching in the same row as the phone number (identifier).
Can this be a single script or will it be many scripts? Can someone guide me in doing this?