compare name and copy to current worksheet

M

Mikke

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 from closed .csv files 0
open excel file and copy data to another file 4
excel 2003 vs 2007 menu and sheet issues 3
Create if partial match then copy and paste data from one cell to another 1
Macro to copy rows into worksheets 4
Put worksheet names from inactive file into cells of active worksh 2
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Copying rows based on four digits and finding a match 6

Top