Automation in Excel: the choices.
Traditionally, the way to automate tasks in Excel, was to use VBA. See this post for how to turn on the developer tab and access this amazing tool. The new kid on the block in terms of automation in Excel is Office Scripts. Both allow you to record your actions, so no real programming knowledge […]
Custom Spreadsheet Solutions – Still going.
I have decided to rewrite some of my old blogs, so this is a rewrite of my first every post where I introduced the business: Custom Spreadsheet Solutions. “A brand new business looking to create customised spreadsheet solutions for organisations.” I am really pleased that I still get to do this work, and the concept […]
Clipboard memory knows what you just copied, and the thing before that as well…
I am generally not a fan of copying and pasting as it is usually an inefficient thing to do. But, sometimes it is helpful and if you are going to do it at least do it well. Did you know that everything you copy is stored on the clipboard memory? This means that you can […]