Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
YouTube on MSN
Create clickable tabs inside an Excel sheet
In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, automatically updating the corresponding data. This technique consolidates ...
How-To Geek on MSN
The game-changing Excel ribbon feature I wish I'd used sooner
Stop hunting through tabs—build a portable custom ribbon containing your favorite commands and Excel's most useful secret tools.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results