Hi,

This one is very difficult for me.

I have 2 files named confirm.xls and export.csv both files have identical data in columnA (starting at A2) but not in the same order and using columnA to match, I need the data from confirms.xls on that same row on columns C,E and F to be written over to the other file export.csv in the the same columns but in the row that they match on columnA.

Example confirm.xls
ColumnA | ColumnC | ColumnE | ColumnF
114919118-1 | FEDX | MP-001 | 1
114911422 | FEDX | MOP305 | 2
114901552 | FEDX | PB05 | 1

Example required output file export.csv
ColumnA | ColumnC | ColumnE | ColumnF
114901552 | FEDX | PB05 | 1
114919118-1 | FEDX | MP-001 | 1
114911422 | FEDX | MOP305 | 2

I have been trying IF(INDEX(confirm.xls!$A$2:$A,MATCH(export.csv!$A$2 :$A)) THEN
and I'm not sure how I would copy that row column C,E and F to to export.csv on the same row as it matched.
I have tried using functions with no success.

I appreciate any help,

David

Hi David

Have you tried using VLOOKUP function. This might be helpful for your case

Also if you want to do using VBA, try using the Find Method and then copy the entire Range (C to F) for each row where the Find is successful

I hope the values in Column A will be unique

The following link can be of some help to start with

http://vbadud.blogspot.in/2007/05/dy...xcel-data.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)