Compare name and copy from closed .csv files
 

Hi All

I need help with excel. I have a master files with names of items on
sheet1 A:A, i want VB to check the name on 12 other .csv files on
Sheet1 B:B and if the name match i want it to copy the number to the
master file Sheet1 AC:AC and check wookbook2 sheet1 b:b then copy to
master file sheet 1 AD:ADwithout opening them? is it even possible?

here's example

CAR summary.xls - master file - has the item name on Sheet1 Column
A1:A765

I want to copy the number in cell from

CAR 1.csv
CAR 2.csv
CAR 3.csv... CAR 12.csv

match the name on CAR1 Sheet 1 Column B8:B900, if true, then copy the
number from C:C900 ( information is found in one cell) ... it will
check all the names, then moves to the CAR2