Relate 2 Tables in Excel Database

I have 2 worksheets as database in Excel. Can I use a query command to retrieve related information from the two worksheets?:help

If you use named ranges for each data set on each sheet, you can use ADO woith SQL. See the thread in SQl for more details.

If you use named ranges for each data set on each sheet, you can use ADO woith SQL. See the thread in SQL forum http://vbaexpress.com/forum/showthread.php?t=14661 for more details.

Thanks.