BlogTips ›Create a Dynamic Dropdown Menu

Create a Dynamic Dropdown Menu

There is a simple solution in Excel that prevents all kind of errors while copy-pasting data from one table to another. Essentially, you can easily create a dropdown menu that will correspond to the data in the first table, even if the data have been changed since. Watch a quick videotip above to see how.