I know, it's originally 2 workbooks but I combined them just for the example. Here, I'll separate them back out; though it does seem that it should work correctly if you have all the locations named appropriately. Either way, here they are again but separated.
--BA Patterson.
Hehe, I was really hoping you were going to upload a sheet that didn't look like that. Your request was unclear and the macro given compares cells in each workbook at the same address. Just listing values in column A of the second workbook means you're in for a macro maintenance nightmare...you'd have to have a line of code for every formula in the first workbook stating specifically which cell in column A of the second workbook to compare it to.
Even the *smallest* of changes in your layout of WB1 would require tons of editing in your macro.
In your WB2, put the expected values in the cells at the same address for the comparisons to work properly. The layout in the updated version is giving me correct comparisons.
Remember that hidden "spaces" will cause text comparisons to fail. E2 failed until I made them actually match.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Re: VBA to compare 2 sheets/workbooks
Sweet Moses! We may be on to something here!
I simply moved from listing them just down the column to making them all match the respective addresses.... Mission success. Only a couple of extra lines I need to add on to this now and I think we may have lift-off!
Thank you very much, you're the man!
--BA Patterson.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks