In this video I demonstrate how to create a list of worksheet names in Excel that you can use as a table of contents. I will show you how to add hyperlinks so that you can easily navigate inside your workbook. The worksheet list (or table of contents) will be dynamic, so if you… Read More »Create a List of All Sheet Names | Dynamic Excel Table of Contents inc Hyperlinks & Auto Updates
In this video I demonstrate how to write VBA code to save a macro-enabled .xlsm file as a normal Excel workbook (.xlsx file). In our scenario we have an invoice template that we use to generate our invoices. A command button, when pressed, automatically saves a copy of the invoice template to a specified… Read More »Excel VBA Macro Save .xlsm File to Specific Location as .xlsx | File Name Based on Cell Values
In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this. Click here to download the featured file Video Table of Contents 00:00 Introduction 00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace Here’s the… Read More »Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro