Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare unsorted data across workbooks
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare data in two different workbooks | Excel Discussion (Misc queries) | |||
How do I compare data in 2 workbooks | Excel Programming | |||
How can I compare data on 2 workbooks | Excel Discussion (Misc queries) | |||
how do I compare workbooks for duplicate data | Excel Discussion (Misc queries) | |||
Is there a way to compare data on 2 different workbooks to find m. | Excel Worksheet Functions |