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