Hi,

I've two worksheets for current month and previous month. I'd like to
compare this two sheets and highlight the different. The key to compare
is Product No in column A.

I could do this using loop to check row by row in the previous month
sheet. And using vlookup to check if the Product No exist in current
month sheet. I wonder if there is more effective method to accomplished
this task. I think the looping row by row is quite slow. And in some
occasion, the Product No was blank that make my vlookup not working
properly (I think).

Your help are appreciated.


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=468402