PDA

View Full Version : [SOLVED] Row Compare - Data not cell



blanchard306
03-11-2016, 02:08 PM
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
03-11-2016, 11:26 PM
can you further explain logic behind your comparision?

blanchard306
03-12-2016, 09:47 AM
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
03-12-2016, 09:54 AM
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
03-15-2016, 03:41 AM
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
03-15-2016, 07:07 AM
Thanks i'm going to be giving it a try today!!