Matching rows for differences
"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
|