Morning Libby,

You are welcome.

It is probably stopping at that code because you need to change the following code

    'You need to change this to the relevant path for the CAP and MAT files
    
    CAP = "C:\temp\CAP Sample.xls"
    MAT = "C:\temp\03-01 MATS agreements sample.xls"
or copy the sample files to the C:\temp directory.

Currently the code expects the CAP file to be in the C:\temp directory with filename CAP Sample.xls and the MAP file to be in the same directory with the sample filename.

I don't know if you intend for the user to go and locate the CAP and MAT files themselves. If that is the case then you would probably want the code above to be


        
    CAP = Application.GetOpenFilename(,,"Please locate the CAP file to be used")
    MAT = Application.GetOpenFilename(,,"Please locate the MAT file to be used")
For the additional columns as long as the two files have the same column headings, you should be able to add as many as you need. At the moment, I think the only limitation is that the code relies on the IF file having more columns (with data) than the other two files. If it is likely that this would not always be the case, please let me know.

Regards