Automate Your Excel Tasks…
(This post is about Macros and VBA. See here for a discussion on other automation options in Excel.) You can automate tasks in Excel. This is done via macros which are coded in a language called VBA. You don’t actually need to be able to write code to benefit from macros. Excel enables you to […]
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 […]