Download the featured file and VBA code here: https://www.bluepecantraining.com/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.

Table of Contents:

00:00 - Introduction
00:49 - Create the data validation drop-down list
01:45 - Use VBA code to hide rows based on drop-down list selection
04:55 - Use VBA code to hide columns based on drop-down list selection
05:42 - Run the macro only when the drop-down is selection is changed
07:02 - Save file as macro-enabled
------------------------