How to Compare Data in Two Excel Sheets #excel

HOW TO COMPARE DATA IN TWO EXCEL SHEETS //
There are 5 different ways that you can use to compare data between two different Excel sheets. They range from simple to more complex, but also more efficient.

0:00 Intro
0:46 View side by side
1:55 Create a duplicate workbook from new window
3:40 Conditional formatting
5:25 Formulas
7:19 Create a macro

Have you used any of these before?

**********************************
Our mission here at LightsOnData is to:

1️⃣ Provide current and future data professionals with increased knowledge and better understanding of data governance, data management, and data storytelling.

2️⃣ Provide simple, fun, and engaging, as well as thorough explanations, teachings, and advice on important, but otherwise boring and dry topics of the data world.

3️⃣ Put the lights on data-focused organizations and products by helping them get more exposure on social media.

Here are ways that you can benefit from LightsOnData's content:

⚡️ ONLINE COURSES: Easy to learn, engaging and highly valued online courses in areas of data governance, data management, and much more:

⚡️ FREE TEMPLATES: Check out our website for more useful content, templates, best practices, definitions, etc. on data governance, data management, data storytelling practices.

⚡️ DAILY TIPS: Follow our LinkedIn page to benefit from daily content on data governance, data management, data quality, data storytelling, and all things data.

⚡️ FUN DATA SWAG: Show others your love for data with any of these fun apparel items and accessories:

**********************************

Connect with George Firican on Social Media:

[howardtiersky]

Great video as always - you explained the process very eloquently too! I love how efficient this is, gonna give it a try. Thanks, George!

[fredpox]

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! 👍

[BobOrf]

I too cannot read the formulas or the VBA code. I would love a copy of the VBA code if you wouldn't mind.

[LightsOnData]

Here is the macro that I used:
"Sub CompareDataSheets()
Dim eachCell As Range

For Each eachCell In

If Not eachCell = Worksheets("Sheet2").Cells(eachCell.Row, eachCell.Column) Then
eachCell.Interior.Color = vbRed
End If

Next eachCell

End Sub"

[yaraocanacalvo]

*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!

[KoreafoodsUK-kfin]

there content is blur with any of video quality

[malachichi]

hi, its impossible to view the formula in section 5 - Formulas, can you please share it here? thank you!:)

[hpaek]

it didn't work. I got an error saying "you may not use references to other workbooks for conditional formatting criteria"

[jagdeepminhas]

Tried on every resolution but video quality seems not ok