To simplify my problem :

This is the result from a webquery on sheet1...
Sheet1:

A1: Joe, B1: Male
A2: Bill, B2: Male
A3: Sue, B3: Female
A4: Cindy, B4: Female
A5: Bob, B5: Male


Then let's say i want to see (in sheet2) all the rows
from sheet1 where gender = male.

Sheet2:
A1: Joe, B1: Male
A2: Bill, B2: Male
A3: Bob, B3: Male

This information needs to change whenever the results
from the webquery on sheet1 changes...

How do i do this?

regards,
Tomas

just use datafilterautofilter and you don't have to see on another sheet

--
Don Guillett
SalesAid Software

"Tomas" wrote in message
...
To simplify my problem :

This is the result from a webquery on sheet1...
Sheet1:

A1: Joe, B1: Male
A2: Bill, B2: Male
A3: Sue, B3: Female
A4: Cindy, B4: Female
A5: Bob, B5: Male


Then let's say i want to see (in sheet2) all the rows
from sheet1 where gender = male.

Sheet2:
A1: Joe, B1: Male
A2: Bill, B2: Male
A3: Bob, B3: Male

This information needs to change whenever the results
from the webquery on sheet1 changes...

How do i do this?

regards,
Tomas