Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel. In Excel 2007 (and earlier), it’s possible to create a drop-down list. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list. In this example we’ll create the following
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/11/24/create-conditional-drop-down-lists.aspx
Posted
Nov 24 2009, 02:46 PM
by
Microsoft Excel