Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

I began writing this series of blogs on Excel for Microcontroller Central. When it was shut down, Brad Albing (then editor of Planet Analog) agreed to copy the existing database across as a base for ...

Excel has native regex support, and it works exactly how you'd expect.