Skip to content

Excel VBA Macro Save .xlsm File to Specific Location as .xlsx | File Name Based on Cell Values

      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

    Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

      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

      Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILTER

        In this Microsoft Excel video tutorial I demonstrate how to copy filtered data to another worksheet automatically. I explore two methods: Click here to download the featured file METHOD 1: Use the Advanced Filter with VBA The advanced filter allows you to copy filtered results to another worksheet but it doesn’t update automatically if you… Read More »Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILTER