I have 2 workbooks, one with 6 columns of data and the other with 12 columns
of data. Both have an unspecified number of rows. The data in the first
workbook(6 columns, A-F) needs to be compared with the data in the second
workbook(12 columns, but only columns G-L need to match the data in the
first worksheet columns A-F). I need to create a 3rd workbook showing the
data in the rows that did not match across the 2 workbooks. The first two
workbook's data are not sorted so the rows don't line up across the
workbooks.

e.g. workbook 1 data columns A-F
SPX OCT 2008 800 0 1200
SPX OCT 2008 900 0 -1400
SPX OCT 2008 975 0 200
workbook 2 data columns G-L
SPX OCT 2008 900 0 -1400
SPX OCT 2008 800 0 1200
SPX OCT 2008 975 0 100

The only data that will show up in the 3rd workbook is
SPX OCT 2008 975 0 200 and SPX OCT 2008 975 0 100

I have tried the excel addins compare.xla and workbook compare, but neither
seems to allow for rows that do not line up across workbooks. I believe I
will need to loop through one of the workbooks in order to check data for
this reason.

If this is at all possible, any help would be greatly appreciated