VBA to compare workbooks
 

morning all.
On a fairly regular basis, we need to update our existing workbooks.
Sometimes we stumble across duplicates, and need to make sure that the data
in both books match, so that we don't inadvertantly miss something of
importance.
Aside from going worksheet to worksheet, using IF equations, is where some
means- VBA, that I can use to check both the names of the worksheets, and
their contents with multiple workbooks?

Thank you.
Best.
SteveB.

VBA to compare workbooks
 

DownLoad Chip Pearsons Compare Add - in

http://www.cpearson.com/excel/Download.htm

"SteveDB1" wrote:

morning all.
On a fairly regular basis, we need to update our existing workbooks.
Sometimes we stumble across duplicates, and need to make sure that the data
in both books match, so that we don't inadvertantly miss something of
importance.
Aside from going worksheet to worksheet, using IF equations, is where some
means- VBA, that I can use to check both the names of the worksheets, and
their contents with multiple workbooks?

Thank you.
Best.
SteveB.