I have posted in your another thread (might be duplicate).
you may copy one sheet to new workbook for comparison temporarily and
use the same compare feature within window menu.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=562471