A
Adam
Hi All,
I need you help.
I have 2 Excel files.
In the file X I have a lot of records, each contains an identifier
and a lot of other columns, lets say B, C,..., K
In the file Y there are only some records with the same identifier
as in the file X but with other columns, lets say L,M,N.
The file Y doesn't contain any records with identifiers which are
not in the file X.
What I need is someting like updating file X by data in file Y,
i.e. a new file Z with all records from the file X where records which
identifiers are in the file Y should have also data in the columns
L,M,N from the file Y.
I don't know how to do it "automatically".
I will be very grateful for your help.
Regards,
Adam
I need you help.
I have 2 Excel files.
In the file X I have a lot of records, each contains an identifier
and a lot of other columns, lets say B, C,..., K
In the file Y there are only some records with the same identifier
as in the file X but with other columns, lets say L,M,N.
The file Y doesn't contain any records with identifiers which are
not in the file X.
What I need is someting like updating file X by data in file Y,
i.e. a new file Z with all records from the file X where records which
identifiers are in the file Y should have also data in the columns
L,M,N from the file Y.
I don't know how to do it "automatically".
I will be very grateful for your help.
Regards,
Adam