a way to append data from 2 different files

[srosetti]

I have two seperate excel files. One of these files is a list of
products and the other file is a sorted one by part number and brand.

What I need to do is basically cross reference the two files so where
the part numbers equal each other I need to append the brand
information from File B to File A.

File A is named Master_File.csv and
File B is named test_lookup_table_brand_part.csv

Sample data from File B
Column A 1683
Column B snma
Column C tscny
Column D altima

this data would need to append to my File A or Master_File in the
following way..

Cross Ref B to A on Column A where 1683 match each other.
Take Data from File B Col B,C,D and append it to existing data. They
all have existing data already, but append to it so it looks like.

Column BA is the area to append to
existing data, existing data, snma, tscny, altima

You can see the operation appended snma, tscny, altima from the File B
to File A, but left the original data in its format.


Any ideas on how to do this? I've thought of using helper columns, but
there are many more rows of information in File A than B. I don't want
to have to copy each row individually and match them up with the
thousands of entries.

They are both CSV files.. File B could possibly remain an XLS too if
that helps.


Thanks

 

[JLGWhiz]

You might get more response if you would convert the .csv files to Excel
files. Most people in this forum work with VBA for Excel.

 

[srosetti]

You might get more response if you would convert the .csv files to Excel
files.  Most people in this forum work with VBA for Excel.

I can change the csv files to Xls no issue.. but still looking for a
solution. anymore ideas from here?