Case Statement

Hide and Show columns with Power Query

Excel Automation, Home Page Post, Macros, Power Query, Ribbon Customization, VBA

I wanted to create a practical example to hide and show columns with Power Query and user selections from a table in a report. In the past I would do this with VBA effectively enough (I will do a post in the future on the purely VBA method I have used) but hey the Power […]

Hide and Show columns with Power Query Read More »

Business Model Renovation Macros Used

Data Cleaning, VBA

Further to my recent post this is one of the Business Model Renovation macros used in this project what I call one of my ‘quick and dirty’ but handy and versatile macros. It has been written this way because as I made changes to formulas in the templates I would just wanted to copy these

Business Model Renovation Macros Used Read More »