Row Compare - Data not cell

[blanchard306]

Okay all great minds out there I am at a stand still. I have two sheets with the 13 columns and ~700 rows I need to know what data is different in each row. NOT what is different by each column/cell just what data is different in each row.

Example

Sheet1

ROW1 GridName

Page1

Page2

Page3

Page4

Page5

Page6

Page7

Page8

Page9

Page10

Page11

Page12

ROW2 AMT002

10857

10858

10859

10860

10869

8007A

ROW3 BG876

10036

10085

10099

10111

10380

461R

8007A

Sheet2 ROW1 GridName Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10 Page11 Page12 ROW2 AMT002 10857 10858 30987 10860 10869 8007A 10859 44532 ROW3 BG876 10036 10085 10099 10111 10380 8007A

So what I am trying to extract or highlight in this example would be great if it would go to a new sheet like this

Sheet	Row	Data 1	Data 2	Data 3	Data 4
Sheet1	Row 3	461R
Sheet2	Row 2	30987	44532

I've done a compare VBA but it will only work for exact row match (i.e. looks cell by cell for each row and highlights the cell on the second sheet that is different. I need it to be the overall row not what doesn't match in each cell in a row)

Thanks for any help!!

[excelliot]

can you further explain logic behind your comparision?

[blanchard306]

I am trying to find out what is different from each row in both sheets. I need to be able to know sheet 1 row 1 had "XXX" but it was not in sheet 2 row and sheet 2 row 1 had "xxx" but was not in sheet 1.

So need to know for each row on both worksheets what data is either not in that row or what data is extra in that row. I'm comparing data from two product extracts and need to know what is missing from each. The first column in each row is a product type and the numbers are the product accessories. I need to know what is different from each so I can make them match. I can't just simply do a remove dups as our system can't just load it that way. I need to know so we can do the research to see if we need to add or delete the product accessory or add it. I have ~700 rows of product to go through.

[blanchard306]

Maybe a little simpler put I need to extract what is different between the two sheets in each row but I need to know which sheet had the extra data. So the data points I need are

Row
Different data
Sheet it came from

So if Sheet 1 row 1 has 1, 2, 3, 5
and Sheet 2 row 1 has 1,2,3,4,5,8,9

since Sheet 2 row 1 had a "4","8" & "9" and sheet 1 row 1 didn't

Results should be
Sheet 2, row 1, 4,8,9

[excelliot]

Hi

Check this file, you need to put data as in sheet 1 & sheet 2, goto last sheet & press blue button to run macro & you will get result as desired.

Cheers!!

[blanchard306]

Thanks i'm going to be giving it a try today!!