How to quickly create dynamic drop down list in Excel?

Most of us may be can create a drop down list by using the Data Validation function in Excel, but sometimes we need to a linked or dynamic drop down list, ...

www.google.com.tw