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!!
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!!