View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
 
Posts: 245
Default 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.