Join statements using ADO across separate Worksheets
 

Is it possible to join worksheets based upon a common column/key over
separate worksheets in the same workbook?

Does anyone have an example query?

Thanks.

Join statements using ADO across separate Worksheets
 

If you set the ranges on the separate worksheets as named ranges
(InsertNameDefine...), you can use standard SQL using the names as the
tables.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
Is it possible to join worksheets based upon a common column/key over
separate worksheets in the same workbook?

Does anyone have an example query?

Thanks.

Join statements using ADO across separate Worksheets
 

How do I define colmns - say I want to join on columns 1 and 2 of
Sheet1 and 2 and 3 of Sheet2?

Do I need a named range for the columns too?

Thanks.

Join statements using ADO across separate Worksheets
 

Yes, but if you use dynamic range names, it will only extend as far as
necessary.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
How do I define colmns - say I want to join on columns 1 and 2 of
Sheet1 and 2 and 3 of Sheet2?

Do I need a named range for the columns too?

Thanks.