Matching rows for differences
OK. I'll bite.
Basic Strategy:
1. Read the data from each of sheets 1 and 2 into arrays.
2. Compare row by row, and identify mismatches
3. Create an array of the mismatched and write to sheet 3
Basic questions:
1. Do we need to check to see if a row on sheet1 exists on sheet2, or do we
need to add a check to ensure that rows on sheet2 exist on sheet1?
2. I assume that row checking means verify exactly the same value in the
same column on each sheet?
Let me know.
Alex J
"Brian Madsen" wrote in message
ink.net...
"Brian Madsen" wrote in message
ink.net...
I 'm in dire need of a solution to this problem, I need to match sheet1
to
sheet 2 by entire rows and show the non matching rows on sheet3. Any
help
with this would be greatly appreciated. I've been working this for a
week
and cannot come up with a solution.
Sheet 1 Sheet 2
Sheet3
1 2 3 4 1 2 3 4
6 7 8 8
2 3 4 5 2 3 4 5
6 7 8 9
6 7 8 9 6 7 8 8
e f g h
a b c d a b c d
e f h g
e f g h e f h
g
(Whoops, looks like I'm also in need of a formatting tutor)
Should look like:
Sheet 1 Sheet 2
1 2 3 4 1 2 3 4
2 3 4 5 2 3 4 5
6 7 8 9 6 7 8 8
a b c d a b c d
e f g h e f h g
Sheet 3
6 7 8 8
6 7 8 9
e f g h
e f h g
|