Skip to content

Auto-Populate Other Cells When Selecting Values in Excel Drop-Down List | VLOOKUP to Auto-Populate

    In this video I demonstrate how to auto-populate cells based on the value selected in another cell’s drop-down list. Click here to download the featured file Video Table of Contents 00:00 – Introduction 00:31 – House your data in an Excel table 01:27 – Define a name for the customer column 02:38 – Create the… Read More »Auto-Populate Other Cells When Selecting Values in Excel Drop-Down List | VLOOKUP to Auto-Populate

    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

      Jump to Today’s Date in Excel | Hyperlink Formula or VBA Macro to Find Today’s Date in Worksheet

        In this video I demonstrate how to find and select a cell containing today’s date. I explore two methods. The first method uses the HYPERLINK, MATCH and TODAY functions within a single formula, and the second method uses a VBA macro. Click here to download the featured file. Table of Contents 00:00 – Introduction 00:16… Read More »Jump to Today’s Date in Excel | Hyperlink Formula or VBA Macro to Find Today’s Date in Worksheet