Rafting adventures in Bosnia and Monte Negro [VIDEO]

Hey Guys!

I thought about apologising for not writing for so long, pretty sure all my 7 subscribers were unhappy about that. Sadly, I had a really busy first half of the year. Well, not sadly to be honest. I had an amazing first half of the year with loads of skiing and lots of travelling. And lots of hard work as well. I’ve been placed in charge of the statutory and internal reporting for the group of entities at my job and it’s been challenging. Challenging yet rewarding. Gained new knowledge and experience and practised consolidations and reporting really well. I like working with deadlines. You get to be done with it and enjoy yourself afterwards. Continue reading...

Custom Ribbon tabs and Macros in Excel

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. Continue reading...