Today I want to share some Excel magic with you. If you are anything like me you probably want to optimize your workflow a lot. One way to do that is using Excel macros. But these require some VBA programming knowledge. I’ve been using macros to save time for quite some time now and want to share my favorite one with you.
Today we are making a macro that assembles many files into one. But what’s more interesting, I am going to show you a way to put this macro as an Excel function, in its own ribbon tab. We are also going to be creating a simple macro to delete empty rows, to make our own ribbon tab look better.