Here is the macro that I used: "Sub CompareDataSheets() Dim eachCell As Range
For Each eachCell In Worksheets("Sheet3").UsedRange If Not eachCell = Worksheets("Sheet2").Cells(eachCell.Row, eachCell.Column) Then eachCell.Interior.Color = vbRed End If Next eachCell End Sub"
*MINDBLOWN*...Im currently ´allergic´ to VBA (lol) so I think the solution for me is the conditional formatting one! But I have given myself a good talking to...and Im going to take some ´VBA anti-histamine´and get on with learning it! ;) Then again, my previous experience of a VBA course I did a good 5 years ago was not a good one :(...the lecturer couldnt care less about the subject matter and kept getting things wrong...that just goes to show how far it goes to be personable, eloquent AND actually care about your audience. So thanks you George again!
Hahaha, I have to remember that, Yara: "VBA anti-histamine". :))) Sorry that you had a bad VBA teacher. Sometimes the best teacher resides in ourselves. :) Yeah, I think that the conditional formatting definitely works. Even better, perhaps, is not having to do it in Excel at all and have it done within a relational database.
@@LightsOnData lol so very true George! I consider myself a Self Starter in all aspects of my life. Nothing has ever been handed to me. Ive had to fight and research for every inch of knowledge I have. Whether its finding a course, or treading through countless hours of research! Thankfully, I am blessed with a great capability to learn and retain quickly :)....now off to research ‘relational databases’...wait! SQL is a relational database! GET IN! 💪🏻 See? Im getting there! 😅 #datageek #datalover
Great content and lovely explanation congrats! I did 1 to 3 in the past. I never thought of 5 but since I'm quite acquainted with VBA I'm going to "steal" your idea and use it for future projects! Definetely the most versatile and reusable! Thanks again and keep it up! 👍
Thank you Paolo. I'm glad that you enjoyed the explanation. It's great to hear that you are acquainted with VBA as using it can definitely bring some efficiencies and automate some processes. Let me know how it goes with it and thank you again for the encouragement and support.
I’m sorry about that. Not sure what’s happening. I’ll check the original video. I hope that you can still get some good takeaways even if the resolution is not great.
Here is the macro that I used:
"Sub CompareDataSheets()
Dim eachCell As Range
For Each eachCell In Worksheets("Sheet3").UsedRange
If Not eachCell = Worksheets("Sheet2").Cells(eachCell.Row, eachCell.Column) Then
eachCell.Interior.Color = vbRed
End If
Next eachCell
End Sub"
*MINDBLOWN*...Im currently ´allergic´ to VBA (lol) so I think the solution for me is the conditional formatting one! But I have given myself a good talking to...and Im going to take some ´VBA anti-histamine´and get on with learning it! ;) Then again, my previous experience of a VBA course I did a good 5 years ago was not a good one :(...the lecturer couldnt care less about the subject matter and kept getting things wrong...that just goes to show how far it goes to be personable, eloquent AND actually care about your audience. So thanks you George again!
Hahaha, I have to remember that, Yara: "VBA anti-histamine". :)))
Sorry that you had a bad VBA teacher. Sometimes the best teacher resides in ourselves. :)
Yeah, I think that the conditional formatting definitely works. Even better, perhaps, is not having to do it in Excel at all and have it done within a relational database.
@@LightsOnData lol so very true George! I consider myself a Self Starter in all aspects of my life. Nothing has ever been handed to me. Ive had to fight and research for every inch of knowledge I have. Whether its finding a course, or treading through countless hours of research! Thankfully, I am blessed with a great capability to learn and retain quickly :)....now off to research ‘relational databases’...wait! SQL is a relational database! GET IN! 💪🏻 See? Im getting there! 😅 #datageek #datalover
@@yaraocanacalvo570 you're smart and funny :)
@@LightsOnData lol 😂 Im glad you think so! Because i think i lost my marbles somewhere along the way...but it’s ok, Ive accepted it! ;)
Great video as always - you explained the process very eloquently too! I love how efficient this is, gonna give it a try. Thanks, George!
I appreciate that Howard. Thank you for your support. Let me know how it went after you’ve tried it out.
@@LightsOnData I sure will! Thanks again, George :)
Great content and lovely explanation congrats! I did 1 to 3 in the past. I never thought of 5 but since I'm quite acquainted with VBA I'm going to "steal" your idea and use it for future projects! Definetely the most versatile and reusable! Thanks again and keep it up! 👍
Thank you Paolo. I'm glad that you enjoyed the explanation. It's great to hear that you are acquainted with VBA as using it can definitely bring some efficiencies and automate some processes.
Let me know how it goes with it and thank you again for the encouragement and support.
I too cannot read the formulas or the VBA code. I would love a copy of the VBA code if you wouldn't mind.
hi, its impossible to view the formula in section 5 - Formulas, can you please share it here? thank you!:)
Definitely. My apologies about that. Here it is: =IF(Sheet1!A1Sheet2!A1,"Sheet1: "&Sheet1!A1 & " vs. Sheet2: "&Sheet2!A1,"")
there content is blur with any of video quality
it didn't work. I got an error saying "you may not use references to other workbooks for conditional formatting criteria"
Tried on every resolution but video quality seems not ok
I’m sorry about that. Not sure what’s happening. I’ll check the original video. I hope that you can still get some good takeaways even if the resolution is not great.