Re: Query in Excel...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 sheet 

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

Relevant Pages

  • Re: How Do You Keep Your Wife In Line?
    ... Bob G wrote: ... >>not to make this a female or a male. ... and does other things to appear male. ... > cross dressers, transsexuals, and transgendered people. ...
    (misc.survivalism)
  • Re: How Do You Keep Your Wife In Line?
    ... Bob G wrote: ... >>not to make this a female or a male. ... and does other things to appear male. ... > cross dressers, transsexuals, and transgendered people. ...
    (misc.survivalism)
  • Re: resin casting
    ... On Oct 29, 9:51 pm, bob prohaska's usenet account ... astonishing was to find female 3-pole JT/JPT connectors ... have stock not listed on the web. ... but unable to supply a standard male ...
    (rec.motorcycles.tech)
  • Re: Custom functions...
    ... This is the result from a webquery on sheet1... ... A2: Bill, B2: Male ... >even a user defined function in VBA which you want to ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Trip Report to follow
    ... Male or preferably Female :-) ... Dr Bob. ... and another thing my memory's not as sharp as it used to be. ...
    (alt.vacation.las-vegas)