| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADO to get data from Worksheet in Same Workbook
Here is an easy one for somebody. I have a workbook where one of the
worksheets contains columns of data and another worksheet is a summary of that data. I can use formulas in the summary sheet. I can also use something like EVALUATE(FORMULA) in VBA. But, is it possible to use ADO to connect to the Data sheet and populate the Summary sheet using queries against that data? tod |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| How can I add the same data to every worksheet in a workbook all . | Excel Worksheet Functions | |||
Linear Mode
