software

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: www.excelforum.com/member.php...oamp;userid=21729
View this thread: www.excelforum.com/showthread...hreadid=519360Hi

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.

quot;loopkid1quot; gt; wrote in
message ...
gt;
gt; Howdy all!
gt;
gt; Here's my problem: I've got a gargantuan spreadsheet with the following
gt; headers:
gt;
gt; A | B | C | D | E | F | G | H
gt;
gt; No. | Supplier # | Supplier Name | Address | City | State | Zip |
gt; Amount
gt;
gt; Is there any way to pull out only data that matches what I'm looking
gt; for and insert it into a separate worksheet?
gt; More specifically, I'm looking only for suppliers where City=Chicago.
gt;
gt; Can anyone help me with this? Thanks in advance for any advice given!
gt;
gt;
gt; --
gt; loopkid1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; loopkid1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21729
gt; View this thread: www.excelforum.com/showthread...hreadid=519360
gt;

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: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=519360
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: www.excelforum.com/member.php...oamp;userid=21729
View this thread: www.excelforum.com/showthread...hreadid=519360Hi

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

Andy.

quot;loopkid1quot; gt; wrote in
message ...
gt;
gt; Hi Ed,
gt;
gt; I certainly can clarify a bit! I'm wanting all of the details from
gt; each row where City=Chicago on a separate worksheet. Basically, I'd
gt; like to be able to look at and/or print just a list of all those
gt; suppliers located in Chicago without printing out the entire list (600
gt; some pages) and going row by row.
gt;
gt; Does that help at all? Let me know what else you need from me, and
gt; thanks!
gt;
gt;
gt; --
gt; loopkid1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; loopkid1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21729
gt; View this thread: www.excelforum.com/showthread...hreadid=519360
gt;

Hey Andy,

You were right...that worked perfectly! Thanks!--
loopkid1------------------------------------------------------------------------
loopkid1's Profile: www.excelforum.com/member.php...oamp;userid=21729
View this thread: www.excelforum.com/showthread...hreadid=519360