Extracting data based on content

[loopkid1]

Howdy all!

Here's my problem: I've got a gargantuan spreadsheet with the following
headers:

A | B | C | D | E | F | G | H

No. | Supplier # | Supplier Name | Address | City | State | Zip |
Amount

Is there any way to pull out only data that matches what I'm looking
for and insert it into a separate worksheet?
More specifically, I'm looking only for suppliers where City=Chicago.

Can anyone help me with this? Thanks in advance for any advice given!

 

[Guest]

Hi

One way is to use Data/Filter/Autofilter. It's really easy! Just switch it
on and filter what you want using the little down arrows at the top of each
column. Once the list is as you like it, I use Ctrl+Shift+8 (or Ctrl+*) to
select it all and then copy it and paste onto new sheet.

Hope this helps.
Andy.

 

[EdMac]

Hi Andy,

Are you looking to pull out all the details or just some information
e.g. total amount for chicago?

If you can say what you want to achieve and why this will help

Ed

 

[loopkid1]

Hi Ed,

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

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

 

[Guest]

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]

Hey Andy,

You were right...that worked perfectly! Thanks!