Skip to content

Excel Tutorial

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