ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2 worksheets compare a range of data, create 3rd worksheet w/diffs (https://www.excelbanter.com/excel-programming/417824-2-worksheets-compare-range-data-create-3rd-worksheet-w-diffs.html)

aileen

2 worksheets compare a range of data, create 3rd worksheet w/diffs
 
I have 2 worksheets, 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
worksheet(6 columns, A-F) needs to be compared with the data in the second
worksheet(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 worksheet showing the
data in the rows that did not match across the 2 worksheets. The first two
worksheet's data is not sorted so the rows don't line up across the sheets.
e.g. worksheet 1 data columns A-F

SPX OCT 2008 800 0 1200
SPX OCT 2008 900 0 -1400
SPX OCT 2008 975 0 200
worksheet 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 worksheet is
SPX OCT 2008 975 0 200 and SPX OCT 2008 975 0 100

Any help is greatly appreciated.



All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com