This video demonstrates how to set up a parameter query used with Excel's External Data range feature to dynamically control which records from the external data source are imported.
Subscription:
This video is immediately available with an Excel Fans subscription
