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.
Create a Dynamic Dropdown Menu
21 July 2015 | Topic:Tips