Hi people,

I have a file with columns A to BD and another file with columns A to BM.

In column A in both files I have a customer ID. I would like to match File1 against File2 using only column A in both files and if there is a match in File2 I want the whole row copied from A to BD to File3 or just a new worksheet. Whatever seems best.
The files contain everything from 100 to 9000 rows. But the main customer file only contains about 6000 rows.

How can I do this? Let me know if you want something to work with and I will make some "dummie" files.