| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I join two separate workbooks? | New Users to Excel | |||
| How do I join 3 separate columns of dates | Excel Worksheet Functions | |||
| join worksheets | Excel Discussion (Misc queries) | |||
| How do I join a date and time that are in separate columns? | Excel Discussion (Misc queries) | |||
| Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Linear Mode
