Re: Query in Excel...

From: Don Guillett (donaldb_at_281.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 12:33:23 -0500

just use data>filter>autofilter and you don't have to see on another *** 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Tomas" <anonymous@discussions.microsoft.com> wrote in message
news:6a0101c47590$259e5390$a401280a@phx.gbl...
> 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
>