T
Tomas
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
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