Author: Charles Barsley

Recently I’ve been working to “automate” my life, well my work reporting at least!  Why spend 3 hours on a Sunday reporting the weeks data if you can

I’m probably slightly behind everyone else discovering this  (only recently have I had a “modern” phone powerful enough! but I have just discovered how brilliant Google Maps “turn

I have started to regularly use slicers in pivot tables so that users can filter by category etc, however I found that often users would resave the document

Watching a macro run is like watching a kettle boil, it takes ages!  However if you time it often you’ll find it doesn’t take as long as you think,

In my Excel workbooks I often have VBA hide worksheets (tabs) that I am not using as “Veryhidden”. Very hidden means that when you right-click on the tabs for