How-To Geek on MSN
Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it
Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
Let's say you wanted to update a ball's rarity to 2. You could run UPDATE > BALL > Mongolia > RARITY > 2.0. DexScript has a ton more features too! All of them can be found within our extensive ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results