PDA

View Full Version : Solved: Comparing two sheets. - I've seen code here before that I like, but I can't find



frank_m
11-23-2011, 08:07 AM
I have two sheets in the same workbook with exactly the same structure, 30 columns and 2,000 rows, with the only difference being just a few edited cells. One of you guys here wrote a really nice routine that reports the before and after differences in a way that I really like, but I have not been able to locate it.

Wondering if one of you recalls that thread. It was posted about 6 months ago I think.

Thanks

frank_m
11-23-2011, 09:05 AM
I found the one I wanted, Post#3 by Ausiebear
http://www.vbaexpress.com/forum/showthread.php?t=38319&highlight=compare+two+sheets

I'm nearly sure I saw this before in a different thread and possibly a variation by a different member here, but Ausiebears seems to be reliable,
I both tested it with several example edits, and I trust his work, and it outputs exactly the way I like.. I'm so happy :cloud9: