Skip to content

Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

      In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. This particular technique requires VBA code which I supply via the link above. Click here to download the featured file (including code). Video Table of Contents 00:00 – Introduction 00:49 – Create the data… Read More »Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

    Hide Already Used Items in Excel Drop-Down List | Remove Item From Data Validation List Once Used

      In this Excel video tutorial I demonstrate how to hide used items in a data validation drop-down list. This technique might be useful if you are assigning tasks to staff and you do not want to assign the same person twice. Click here to download the featured file. Video Table of Contents 00:00 – Introduction… Read More »Hide Already Used Items in Excel Drop-Down List | Remove Item From Data Validation List Once Used

      Create a Dynamic Monthly Calendar in Excel 365 or Online | Dynamic Calendar Excel Formula

        In this video I demonstrate how to create a dynamic monthly calendar in Excel 365 or Excel Online. The calendar uses the following functions DATEVALUE, WEEKDAY and SEQUENCE. Using conditional formatting the calendar highlights bank holidays and the current date. Click here to download the featured file. Video Table of Contents 00:00 Introduction 00:22 Create… Read More »Create a Dynamic Monthly Calendar in Excel 365 or Online | Dynamic Calendar Excel Formula