Extracting data based on content

L

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

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

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
 
L

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
 
Top