Query in Excel

  • Thread starter Thread starter Tomas
  • Start date Start date
T

Tomas

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA help: Text file formatting 19
My Never ending ARRAY code problems 18
Query in Excel... 1
i = row number of last occurance of duplicate string Column A 4
VBA Countif across sheets? 5
Array to Multiple Arrays 3
Array code troubles 4
Count cells containing text, multiple criteria 2

Back
Top