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

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍

Download the featured file and VBA code here: https://www.bluepecantraining.com/wp-content/uploads/2023/01/Hide-Rows-or-Columns-Based-on-Drop-Down.zip

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
------------------------

Видео Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List канала Chester Tugwell