Upload

Loading...

Dynamically Update a Drop Down Menu/List - Data Validation & OFFSET() Function

229,965 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Dec 29, 2008

http://www.TeachMsOffice.com
This tutorial will show you how to have a dynamically updated drop down list in excel; how to make your data validation drop down list or menu dynamic. This means that every time you add something to the list the drop down menu will automatically include that item in its list.

This uses the OFFSET() function the COUNT() function and Data Validation in Microsoft Excel.


To get the spreadsheet used here of for more excel video tutorials, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions.

Have a great day!

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...