I have 2 worksheets as database in Excel. Can I use a query command to retrieve related information from the two worksheets?
I have 2 worksheets as database in Excel. Can I use a query command to retrieve related information from the two worksheets?
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber