👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
📗 Get your free template here: »» cutt.ly/up4v2006MFD
🎯 Let your pivot table do all the work to populate your dropdown lists, so you don't have to. All you need to do is click refresh! Your dropdown list is populated by pivot table.
👀 3 Great Ways to Make a Dynamic Drop Down List in Excel: »» • 3 Great Ways to Make a...
======================================================================================
🕑 Video Timings:
00:00 Overview and Demonstration
01:32 The Secret Technique
02:51 Create the Dynamic List
04:36 Link Lists to Drop Downs
05:20 Link Active X Combobox
09:38 Dealing with Multiple Pivot Tables
11:14 Method Summary
======================================================================================
🥉 You can make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list.
Combo box: You can add a Form Control or an ActiveX Control combo box. If you want to create a combo box that enables the user to edit the text in the text box, consider using the ActiveX Combo Box. The ActiveX Control combo box is more versatile because, you can change font properties to make the text easier to read on a zoomed worksheet and use programming to make it appear in cells that contain a data validation list.
Pick a column that you can hide on the worksheet and create a list by typing one value per cell.
Note: You can also create the list on another worksheet in the same workbook.
Click Developer » Insert.
Note: If the Developer tab isn't visible, click File » Options » Customize Ribbon. In the Main Tabs list, check the Developer box, and then click OK.
Pick the type of combo box you want to add:
Under ActiveX Controls, click Combo Box (ActiveX Control).
Insert combo box
Click the cell where you want to add the combo box and drag to draw it.
======================================================================================
📖 there's a pivot table that happens to show some customers sales and profits for various different uh regions for example and what i wanted to do was link a drop-down list to this that could be for data entry or for producing some other function on the spreadsheet like maybe charts dashboards that kind of thing and i wanted this to happen dynamically because the thing about drop-down lists is you link them to a range of cells and then that cell list changes and you drop down this doesn't unless you re-link it to more cells so i've put on the three different types of drop-down lists data validation lists form control and activex controls so if you don't know what those are don't worry i've got another video that talks you through all of those and why you might want to use one versus another pros and cons etc etc link in the description for sure may even be on your screen right now if you want to look at it so anyway what i've done is this list here shows everybody in this pivot table when i change the list up here we now get a different list of names which represents what's in the pivot table at the moment very useful in d
so have i done it well i've used a little uh helper so we just need to unhide this row one what's our little helper an item count so all i've done is said count how many items there are in the pivot table and the minus one is just because i've got a grand total at the bottom of the pivot table so simple count a which counts text count straight count count numbers only minus one okay so we know the
======================================================================================
#Up4Excel
#Up4ExcelControls
#Up4ExcelIntermediate
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
You get new video releases every week, packed full of ways to save time and impress those around you.
💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾
cutt.ly/Up4ExcelSub
======================================================================================
👀 Learn more with my playlist: Drop Down List Techniques for Excel
»» • Drop Down List Techniq...
💥 Get a Shortcuts Cheat Sheet: »» www.up4excel.co.uk/shortcuts
🔑 Remove Excel File Open Passwords: »» • Excel File Locked? Lea...
🎁 Feel free to donate - your small gift will help me make better videos for you and others.
Thank You: www.paypal.me/Up4Excel
👉 Get ALL Up4Excel workbooks and templates on YOUR device in a structured searchable index….with free lifetime updates
📕 Up4Excel Downloads Pack: »» ml.up4excel.com/downloads_pack