Hi!
Is there a way to add rows with a data from one file to other based on cell similarities? Using Excel UI tools, VBA or formulas, whatever.
For example, in the first file there is a complete database of clients, e.g. 1000 rows with records divided into 3 columns. Column A contains clients unique IDs, B column – clients names, C – number of deals.
In the second file there are 250 rows of records and four columns. A and B columns are random clients IDs and names from the same database as in the first file, but C and D columns contain new data I need to merge somehow to the first file’s same clients respectively.
The question. How can I map those nonsequential 250 rows with new data respectively to the same IDs rows between those 1000 records (not overwriting anything)? Thus, I should get the first file with its A,B,C + new D and E columns (which were previously C and D columns in the second file).
Is there a way to add rows with a data from one file to other based on cell similarities? Using Excel UI tools, VBA or formulas, whatever.
For example, in the first file there is a complete database of clients, e.g. 1000 rows with records divided into 3 columns. Column A contains clients unique IDs, B column – clients names, C – number of deals.
In the second file there are 250 rows of records and four columns. A and B columns are random clients IDs and names from the same database as in the first file, but C and D columns contain new data I need to merge somehow to the first file’s same clients respectively.
The question. How can I map those nonsequential 250 rows with new data respectively to the same IDs rows between those 1000 records (not overwriting anything)? Thus, I should get the first file with its A,B,C + new D and E columns (which were previously C and D columns in the second file).