Dependent Drop Down list function in MS Excel || Basic to Advance Microsoft Excel

Publicado el: 14 noviembre 2021
en el canal de: codebusted

Dependent Drop Down list function in MS Excel || Basic to Advance Microsoft Excel || Learn Microsoft excel in just one minute.

This kind of lists are called dependent dropdowns, since the list depends on another value. They are created with data validation, using a custom formula based on the INDIRECT function and named ranges. This may sound complicated, but it is actually very simple, and a great example of how INDIRECT can be used.

*****************************************************************
Watch our other videos on VBA Macros
***********************************************************************
1) Add Serial number By VBA Macro -    • Add Serial numbers in excel by Macro || Ba...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2) Insert Multiple Columns by Macro -    • Insert Multiple columns in excel by Macro ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3) Insert Multiple Rows by VBA Macro -    • Insert Multiple rows in excel by Macro || ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4) Auto Fit Cells by using VBA Macro -    • Auto Fit Row & Columns by Macro || Basic t...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5) Highlight Duplicate values by VBA Macros -    • Highlight duplicate by using Macro || Basi...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
6) Hide & Unhide inactive worksheets by VBA Macros -    • Hide & Unhide inactive worksheets by Macro...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7) Delete all Inactive worksheets by Macro -    • Delete all Inactive worksheets by Macro ||...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8) Protect or Unprotect sheet by using Macro -    • Protect or Unprotect sheet by using Macro ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
9) Delete all blank worksheets by using Macro -    • Delete all blank worksheets by using Macro...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10) Protect all blank worksheets by using Macro -    • Protect all blank worksheets by using Macr...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

***********************************************************************
For More Exciting video's Click on the link -    • Excel - Fast track
***********************************************************************

Quickly learn Microsoft Excel advanced formulas || Learn Smartly

Learning should always be easy and fast. Codebusted videos are meant to make your learning experience smooth, easy to understand, short, and precise. Subscribe and embark on a journey of fast-track learning.

Post any technical queries, We are here to resolve your all technical query..

Write us on - https://codebusted.com

#checkbox
#exceltips
#Excel

En esta página del sitio puede ver el video en línea Dependent Drop Down list function in MS Excel || Basic to Advance Microsoft Excel de Duración hora minuto segunda en buena calidad , que subió el usuario codebusted 14 noviembre 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 32 veces y le gustó 2 a los espectadores. Disfruta viendo!

625