| 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using ADO to get data from Worksheet in Same Workbook | Excel Programming | |||
| Get data from another worksheet in same workbook | Excel Programming | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Threaded Mode
