what if
Sheet 1
ID B C D
A1 2 4
A2 3 5
Sheet 2
ID B C D
A1 3 4
A2 1 4 5

in A2 column C. would you take the 3 or the 4?

"sanjay" wrote in
message ...

Sorry Patrick,

I hope this makes sense:

Sheet 1
ID B C D
A1 2 4
A2 3 5
A4 4 4
A5 5 5

Sheet 2
ID B C D
A1 3 4
A2 1 3 5
A3 5 6 7
A6 6 6 6


Sheet 3 (merged sheet)
ID B C D
A1 2 3 4
A2 1 3 5
A3 5 6 7
A4 4 4
A5 5 5
A6 6 6 6

Regards,

Sanj


--
sanjay
------------------------------------------------------------------------
sanjay's Profile:
http://www.excelforum.com/member.php...fo&userid=5915
View this thread: http://www.excelforum.com/showthread...hreadid=394780