See how to create a Dynamic Data Validation Drop-Down List in a cell using either the Table / List feature or the OFFSET function. See The VLOOKUP function and a dynamic range for that.
http://www.youtube.com/watch?v=2UDRm-hU0Jw&hl=en
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?
Subscribe to:
Post Comments (Atom)
Deixe o seu comentario
Post a Comment