Comparing List

[everscern]

Please Login or Register  to view this content.

So far, I've up to this code which works. But.. it does not compare with column T onwards.

\1

Can anyone help me pls? I'm really at wits end. Thanks.

[Myles]

I'd love to help but the structure of your code is hard to follow-particularly when some loops are condensed to a single line followed by a structured conventional loop.

[everscern]

Thanks for your response.

Could u propose another macro?
I'm really having a hard time with this.

My purpose is to compare column B with column S, T etc. Upon comparison, the output will appear in cell B24. To complicate things, I hope to make this macro automatic thru worksheet change. As worksheet change cannot appear more than once, it makes this macro more tedious.

[everscern]

Please Login or Register  to view this content.

thought of sharing with u guys, because i finally got the code for my above question. Thanks for providing any help !