Re: Extracting data based on content

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

Hi

Using my suggestion of Data/Filter/Autofilter should do the job for you.
There is an intro to using this feature here:
http://www.contextures.com/xlautofilter01.html

Andy.

"loopkid1" <loopkid1.249klz_1141675206.9904@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:loopkid1.249klz_1141675206.9904@xxxxxxxxxxxxxxxxxxxxxxxx

Hi Ed,

I certainly can clarify a bit! I'm wanting all of the details from
each row where City=Chicago on a separate worksheet. Basically, I'd
like to be able to look at and/or print just a list of all those
suppliers located in Chicago without printing out the entire list (600
some pages) and going row by row.

Does that help at all? Let me know what else you need from me, and
thanks!


--
loopkid1


------------------------------------------------------------------------
loopkid1's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21729
View this thread: http://www.excelforum.com/showthread.php?threadid=519360



.

Relevant Pages

  • Re: cross-reference of Office 2003 programs menu, sub-menu and to
    ... "commenting on a feature in a product that anyone who has actually seen ... > Having read the presentation Beyond Menus and Toolbars in Microsoft Office ... > designer for the Office UI suite, and learnt that the menu interface had ... Your suggestion will be ...
    (microsoft.public.office.misc)
  • Re: Is there automatic complete option in Word?
    ... Open Office does have this feature. ... autocomplete suggestion the next time you type "hom". ... > don't even like it on the Pocket PC. ... > Please respond in the newsgroups so everyone can follow along. ...
    (microsoft.public.word.newusers)
  • Re: Put your wish list for SP3 for Office 2003 here
    ... When I want a feature in an office ... the times I thought I was making a suggestion to MS was a waste of typing. ... > reading. ...
    (microsoft.public.office.misc)
  • Find feature
    ... I have a fundamental suggestion for the Find feature in Excel. ... It seems that the Find feature searches the Excel sheet starting at the ... selected cell. ...
    (microsoft.public.excel.misc)
  • Re: Source code size and debug disabled
    ... different to the C++ compiler, could this be a feature introduced by the ... My suggestion would be to split the one huge file down into a number of more ... feature of producing a lib rather than a dll. ... >> After the limit source line information is not available. ...
    (microsoft.public.vc.debugger)