Compare name and copy from closed .csv files

M

Mikke

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare name and copy to current worksheet 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
CSV files and having numbers and strings in there... 9
Populating entire rows of data from a master sheet? 3
Summing one column based on criteria from two other columns 2
Use external file variable in formula 2
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) 2
make copies of sheet and name them from list 4

Top