compare workbooks

Hello Everyone,

I want to know is there a way I can check workbooks, and compare it to make sure they have the same exact data.

I am running 38 workbooks from 2 different location and in each workbooks I have 12 worksheets name (Jan, Feb, March, April.. Dec) so in theory I end up having 76 workbooks...

I want to make sure that workbook Table01_cue.xls sheet (Jan) match up with workbook Table01_Master.xls sheet (Jan) all the way through worksheet Dec. So I would be comparing 2 workbooks at a time with 12 worksheets and making sure that they ALL have the same exact data, including text...

And if the data doesn’t match up I would like it to tell me where it doesn’t match up…


Please help!!!


Let me know if you need more information… please please help!!

Hi Dave,

First I would like to say Thanks for helping!!,

I test your code(s) but it's not looping through the 12 sheets... in 2 workbooks, it only looking for "hi" in the workbook...

what i need to do is, have it look at workbook Table01_cue.xls sheet Jan and workbook Table01_Master.xls sheet Jan and make sure that they are exact same data including text, and if the data isnt the same, give me a message stating that sheet Jan in Table01_cue.xls range A8 is not the same as sheet Jan in Table01_Master.xls range A8 ....

sorry does this make sense?

again, thank you

Hi Dave,

yes, the codes loop though the workbooks to make sure there is Jan and Feb... I still need it to check sheet Jan (A1:N70) workbook Table01_cue.xls and compare it to sheet Jan (A1:N70) workbook Table01_Master.xls to make sure it have the exact data...

thank you for your help and I really appericate this.

Hi Dave

If the data is different,then a pop up saying which sheet and range is different... is that possible... ?

Hi Dave!

Thank you soo much, that work wonderful... it was just want i needed..to be able to select the worksheets and compare it ..thanks a bunch!!!

Ok i got ahead of myself... I was overly excited to see that it test the worksheets and compare 2 worksheets at a time... I am sorry about this, ... but how can i get it to test ALL the worksheets in the workbook and loop it through?


thanks for your help and patience

That is going to be a slow routine. It would be much quicker to copy the data from a known correct workbook 76 times than to check the contents of 76 workbooks.

Hi Dave

The purpose of this project to make sure that both end(s) are pulling the correct data... Last year when we had a lot of errors with numbers not matching up... so this year we would like to be sure that the numbers we're pulling from are the correct one...

That is going to be a slow routine. It would be much quicker to copy the data from a known correct workbook 76 times than to check the contents of 76 workbooks

in regards to your question mikerickson: if we could pull from the correct data that would be wonderful, but the thing is, our numbers change frequently , this is for publication purpose... and we have to run it through 3 server before it is ready to go... a little confusing, a little more work, and a little frustration..but getting the correct data is really important...

thanks for the advise and help.