I'm trying to create a macro that will compare data in two seperate files (spreadsheet A and B) and if it matches, return the data.

Here's the details. The macro will look at columns B, C, D, and E in spreadsheet A. If column B matches column C in spreadsheet B, then add columns C, D and E from spreadsheet A into columns J, K and L in spreadsheet B.

Any help would be greatly appreciated it.