Posted to microsoft.public.excel.programming
|
|
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.
|