Compare Everything in Excel Part 1: Workbooks
HTML-код
- Опубликовано: 23 июл 2024
- Check also and download CompareXLS Excel Addin here: excelmacrobusiness.blogspot.c...
This is part of a mini-series to learn to how to compare everything in Excel using VBA macros. In this video we see how to compare workbook properties. We can use this to compare two or more workbooks. Workbook properties may include the name, path, author, date created, file size, number of sheets, etc. Additionally, I introduce CompareXLS, which is a powerful Excel Add-in that allows to compare workbooks, worksheets, and datasets. In the next video of this mini-series (Compare everything in Excel), we will see how to compare worksheets, including worksheet properties and cell-to-cell comparison.
You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the blog under the link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)
Absolutely love your channel!
I pretty much watch every video as it's released and it's lovely to see your subscriber count growing - you deserve many more RUclips eyeballs.
Thanks for all that you share.
✌️
Glad to hear that Ben, much appreciated.
Great video. Can you do a video on how you created the code to add the "Add-in" to the menu? That is so cool.
Sure thing, I was planning to show more about Add-ins, there's a lot to cover. It's definitely on my list, not sure though when I'll find the time to do all these things, but trying!
How can you compare 2 workbooks that have similar data but is organized and labeled differently?
That's kind of broad, there are many things you could compare. The first thing that comes to mind is probably comparing the sheets in each workbook (number of sheets and names). That's already covered in this video and the other video about comparing 2 workbooks: ruclips.net/video/4lLlX_pXoA0/видео.htmlsi=tOInbXHCRrTAuNNe
Then you say the data is similar but it might be organized and labeled differently. So, starting with "labeled", I assume we are talking here about the headers for each column with data - I suppose. In such case, you could do a cell-to-cell comparison targeting only the headers. Now, if they are different positions too, it gets more complicated. If the data is exactly the same but header has different label and may be in another column (differently organized as you said), then you could have a formula to get a result that allows to find the equivalent column in the other workbook (for numbers only), or have a loop do a cell-to-cell compare to see if it's the same data column, and so on. I am just throwing some ideas, but the topic is endless. Check the other videos too, comparing worksheets and data sets, that may give you some ideas.