| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query in Excel
Hi,
I have a webquery that returns information into sheet1... Now I want to get the rows that have "ABC" in field no4 into sheet2. I was trying to create a function in vba with the following parameters: results_from_webquery as array, criteria_field as integer, criteria as variant Then I wanted the function to create an array that contained only the rows that met the criteria and return them to the cells next to the formula (on another sheet)... this is not working out for me... What is the best way to do this? regards, Tomas |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Query in Excel
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
![Tomas[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
