will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Cascading lists and kangaroos? Today, Ed Ferrero shares his technique for creating dependent data validation drop downs, based on pivot tables. Ed's from Australia, and it looks like we'll learn a bit about his country too, as we go through his sample file.
Dependent Data Validation
We've created dependent data validation drop downs before, based on [...]
Recent Comments