Other Links
This webpage is an extract of the downloadable
Tutorial on Excel
The drop-down lists in Excel
Lesson 2-2: Excel Drop-Down Lists and Data Validation
Part 6:
Applications developed with drop-down lists
Build a single report template and with SUMPRODUCT just select a branch, department, a city...among 50 and the report is AUTOMATICALLY refreshed. No more spreadsheets with 600 reports to maintain (12 months and 50 cities). In a dynamic report you can choose the city and you can choose the month and the Balance Sheet is AUTOMATICALLY refreshed. See how it is done in "excel-example-dynamic-report.xls".
Here is an invoice where you select the name of the client and the name of the product. When you select the client his address appears automatically in the other cells when you select the product its number, and unit price appear in the other cells. No more mistakes, no more typos. See how to do this with detailed explanations in "excel-template-invoice.xls".
Using the drop-down lists and the SUMPRODUCT function you can also do some dynamic charting where a single chart shows you alternatively the results for any department that you choose in the DDList. See "excel-example-dynamic-charts.xls"
In Part 1 you will discovered how easy it is to create a drop down list in Excel
In Part 2 you will discover how to use a range of cells addresses as source for Excel drop down list
In Part 3 you will discover how to assemble all your lists on a single sheet to maintain them easily and how you can refer to a list on another sheet to feed a drop down list. (in the downloadable tutorial)
In part 4 you will discover how to create cascading drop down list where the values offer in the second drop down list depends on what has been selected in the first one. (in the downloadable tutorial)
In Part 5 you will discover how to modify, extend and delete your drop down lists
In Part 6 you will discover different ways to automate your reports with drop down lists in Excel
This webpage is an extract of the downloadable
Tutorial on Excel