Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
If you don't want to include Mouse Follower files in your project, you can use it from CDN.
This project is released under the MIT License. There was an error while loading. Please reload this page.