Extracting data based on content
 

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!


--
loopkid1


------------------------------------------------------------------------
loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=519360

Extracting data based on content
 

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.

"loopkid1" wrote in
message ...

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!


--
loopkid1


------------------------------------------------------------------------
loopkid1's Profile:
http://www.excelforum.com/member.php...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=519360

Extracting data based on content
 

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


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=519360

Extracting data based on content
 

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...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=519360

Extracting data based on content
 

Hi

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

Andy.

"loopkid1" wrote in
message ...

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...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=519360

Extracting data based on content
 

Hey Andy,

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


--
loopkid1


------------------------------------------------------------------------
loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=519360