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