Group,
Can someone show me a compact comparison routine that will check cells one to one, only checking cells within the boundaries of the last column with text in it and the last row with text in it. One spreadsheet may have 2000 rows and the other usually has a few more rows added, appearing in appearing in the beginning, middle or end of the spreadsheet. In some rows a single cell may change.
Everytime I try this problem, I get my self lost in mulitple For....Next statements and If....End If statements. Your assistance here can help a budding VBA programmer.

Thank you for your assistance.....

Tony