See also
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SirDomino" wrote in message ...

I am attempting to pull data that meets certain criteria out of a
spreadsheet and have it imported into a blank spreadsheet.

I have 5,000 records in Excel 2003 with fields for the Company Name,
Address, City, State, and Zip.

I would like to specify a city and have all the records that match that
criteria, copied out of the spreadsheet and then imported into a new
blank spreadsheet. So the new spreadsheet will only contain records
that match the city I specify.

I have been trying to do this for days, and I searched the forums
without any luck.

I would appreciate any help you guys could give. I look forward to
your responses. Thanks!




--
SirDomino